Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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...
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...
Thank you.