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 · Accepted solution]

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}

[Phillip Feigh]

Thank you for your time and response, Kim. I entered that and it appears to have accepted it. The Import completed without errors. Unfortunately, it did not appear to populate the Cost Center, so that is my next hurdle. 😉 Thanks again!

[Kim Euker]

Had you imported your cost centers prior?  Unless you set up the options to add missing items, it will just validate against your cost center