csv import and links between objects

[Heiko Lotz]

I need help with importing csv files and linking objects.

I have two csv files: customers and (as a child of customers) employees of the customer:

Customer object Attributes:
Name (type standard, text), customer number (type standard, integer)

Employee object Attributes:
Employee name (type standard, text), CustomerNo (type standard, integer), Ref customer (type object, object customer, reference)

The customers were all imported via csv. When importing the employees, a link should now be created between the customers and the employees via the customer number (Customer) / CustomerNo (Employee).

I have mapped the fields when importing the employees via csv:

csv.name > employee name
csv.customer number > CustomerNo
csv.customer > Ref customer (AQL: CustomerNo ={CustomerNumber})

How can I ensure that the Ref customer field is linked to the customer during the import? I allready tried several AQL-statements but had no luck.: CustomerNo = CustomerNumber, CustomerNo = ${CustomerNumber}

I would be delighted to receive a tip.

[Christopher Yen · Accepted solution]

Hi @Heiko Lotz

I think the AQL might be this if I'm understanding your screenshots correctly 

"customer number" = ${CustomerNumber}

[Heiko Lotz]

Thank you so much! Made me very happy!

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Heiko Lotz and welcome to the community,

While using the AQL to bind objects you have to keep this in mind. E.g. you have this AQL:

CustomerNo =${CustomerNumber}

CustomerNo should be the insight attribute and

CustomerNumber should be the column name of your csv.

That would be the case for 1-to-1 mapping. Make the corrections and try again. Let me know how it went.

[Heiko Lotz]

Hello an thank you !!!

Now I am totaly confused. This is what it looks like:

ATTRIBUTES OBJECT CUSTOMER

ATTRIBUTES OBJECT EMPLOYEE

IMPORT-MAPPING

employees.csv

Name; CustomerNumber
Anton A;10001;
Berta B;10002;
Caesar C;10002;
Daniel D;10003;
Emil E;10001;
Fridolin F;10002;
Gerda G;10004;

[Heiko Lotz]

It is still not working. Dont know how to link the objects.

[Alex Koxaras _Relational_]

Hi @Heiko Lotz try "customer number" = ${CustomerNumber}, that is the attribute "customer number" contains numbers just like the csv (e.g. 10001, 10002 etc).

[Heiko Lotz]

You are totally right! That is the solution!

Thank you so much :-) You made my dax.