relationships in data reader

Hello,

I want to fill in a dimension in my data reader based on entity related to another in my file. Please, find below my example:

I want to fill in AT - Recepteur Entity based on Company entity which is relathionship with CFI - Valeur il my example. Is there a way to do this ?

thank you!

Find more posts tagged with

In the Data Reader’s ETL tab, add a transformation for the AT - Recepteur field.
Example pseudo-syntax:LOOKUP("Company", [CFI - Valeur], "CompanyID", "RecepteurID")
- This maps CFI - Valeur (source field) to the Company entity key—returning the corresponding AT - Recepteur.

BOARD supports multi-dimension mapping: define a rule that sets AT - Recepteur based on the combination of Company and CFI - Valeur.

Go to the Mapping section → select the AT - Recepteur dimension → switch to the Multi-Dimension tab.
Create a rule: match when Company = X AND CFI - Valeur = Y, then set AT - Recepteur = Z.
This is flexible for conditional mapping across multiple dimensions.

also let me know if it works for you???

In the Data Reader’s ETL tab, add a transformation for the AT - Recepteur field.
Example pseudo-syntax:LOOKUP("Company", [CFI - Valeur], "CompanyID", "RecepteurID")
- This maps CFI - Valeur (source field) to the Company entity key—returning the corresponding AT - Recepteur.

BOARD supports multi-dimension mapping: define a rule that sets AT - Recepteur based on the combination of Company and CFI - Valeur.

Go to the Mapping section → select the AT - Recepteur dimension → switch to the Multi-Dimension tab.
Create a rule: match when Company = X AND CFI - Valeur = Y, then set AT - Recepteur = Z.
This is flexible for conditional mapping across multiple dimensions.

also let me know if it works for you???

Hello Prince,

Thank you for your answer! The lookup formula has only 3 arguments, so I didn't manage to make it work. I will try your second solution.

Have a nice day!

Hello @Catalina
Welcome😊!!
Let me know if it works for you.

Have a nice day!!!