Asset Attribute CSV

[hugo guerin]

Hi all,

I have a little problem with my assets attribut. I have import several csv and i would like to join us by Asset Attribute Name.

I have 2 asset attribute :

Name and Link

For Name i have 2 Data Locator:

Reference and ID

For Mapping my csv I now that i need to use AQL, but when i want to use

Label = ${Reference} + ${ID} 

That doesn't work, 

If you have a idea tell me :)

[JM Perrot · Accepted solution]

Hi @hugo guerin ,

You want to concatenate the reference and ID to create the object name in Asset, right?

The easiest way is to create a new column in your CSV file with CSV_Name as the title and use the formula below:

Then you copy and paste the new column with a special paste to keep only the text and not the formula.

And you can map your name to Asset without an AQL expression, simply by selecting the right destination attribute with the right data source attribute.

If I don't answer the question , let me know :)

[hugo guerin]

Hi JM Perrot,

Thanks for replying, I already think to this solution but i don't want to change all my csv file.

I think it's possible to use mapping object AQL directly if you know the syntaxe that i need to use for Label = ${Ref} + ${Id} tell me :)

[JM Perrot]

In theory it's possible to concatenate two DB's objects to one Asset's attribute. I already follow the documentation but without success for me ^^ But maybe you will have more success than me, I hope :

• Import multiple values into single field 
• Importing CSV files 
• Create an import structure