How to link my tables ?

[Anonymous]

Hello to all,

I have some problem with a load script. I have 3 tables with this limit column

LignesCommande     Commande     Segmentation

-Order_ID                  -Order_ID       -Cli_Code

-Period                      -Cli_Code       -Period

My tables LignesCommande and Commande is already link through Order_ID and I have to add a new table Segmentation.

In Segmentation table I have to create a concatenate column (Cli_Code and Period) and I have to link with a table LignesCommande.

My question is: How to brink the column Cli_Code in a table LignesCommande present in table Commande to make the concatenation (Cli_Code and Period) and link table Segmentation and table LignesCommande ?

Any help or idea please ?

[slondono · Accepted solution]

You can use an Appymap to bring Cli_Code to LignesCommande

Map_Commande:
Mapping

LOAD

     Order_ID,

     Cli_Code

From  Commande (You put here the route or file)

LignesCommande:

     LOAD

     Order_ID,

     Period

     ApplyMap('Map_Commande',Order_ID,'Not matches found') as Cli_Code

From Whathever...

[Anonymous]

Thank you.