I'm getting an error when trying import into Assets

[Jim Smith]

I have a schema with an object of "Hardware Assets" with sub objects of "Laptops", "Phones" and "Tablets".  The Laptops object is already populated with data with Serial Number being the key.

I have another Object, "Employees" which is empty and I have a CSV file has the employee name, email, and the serial number of the laptop assigned to them.

when trying to create the import for this object, The fields I'm trying to associate is the "Serial Number" to go to the "Laptop Assigned" field on the CSV which I'm trying to link back to the "Laptops" object by using the AQL "name = ${Laptops}".  I get the error, "Invalid placeholders in the AQL for attribute Laptop. Placeholder laptops is not present as data locator" and I can't figure this out.  Help?

[Gikku · Accepted solution]

@Jim Smith Try using the AQL as "Name = ${Laptop Assigned}" where 'Laptop Assigned' is the name of the column that you have in your CSV file.

[Jim Smith]

@Gikku I did try that, and I actually needed to change it to "Label = ${Serial Number}" in order for it to work.  thank you for the help!!