What valid AQL statement is needed?

Phillip Feigh

 

Novice user here. I am using a .csv file to import the costCenter attribute to the Users schema. The .csv file data source fields are: userPrincipalName, sAMAccountName, costCenter. These are mapped to destination attributes On Premises Principal Name, On Premises SAM Account Name, Cost Center, respectively. It is prompting for "Enter a valid AQL statement" for the Cost Center. I am unsure what to do. Thanks in advance for any feedback.

 

Kim Euker

When you have a field that you are mapping to another "Linked" Attribute (Asset field), you need to specify an AQL statement for that.  

The statement below assumes I know certain things about your Assets.  

Name is the key (label) used in your cost center table
costCenter is the name you used above in your mapping example

Therefore, your AQL would look like this.

Name=${costCenter}