topic Re: How to link my tables ? in GeoAnalytics

How to link my tables ?

Anonymous — Mon, 12 Jun 2017 08:01:41 GMT

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 ?

Re: How to link my tables ?

slondono — Wed, 14 Jun 2017 18:54:27 GMT

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...

Re: How to link my tables ?

Anonymous — Thu, 15 Jun 2017 07:57:20 GMT

Thank you.