Hi,
You can TAB1 & TAB2 information seperately. Once loaded, then you can try correlating the information together. I have stroed the information in following format:
Data.csv
lastname, name, service_tag, birthday
Rosenberg, Joseph, REF4A, 25/05/1982
Attali, Dan, REF4A, 18/07/1981
Salcherd, David, REF4B, 12/01/1959
Sherman, Gad, REF4C, 07/07/1974
Data1.csv
raining, price, services_concerned
communication, 1024€, REF4A
security, 1344€, REF4A:REF4B
managment, 2745€, REF4C
Please note: multiple services_concerned are represent as : (colon) seperated values.
Then, using following query, I was able to establish the relation.
|inputlookup Data.csv | join max=0 service_tag [|inputlookup Data1.csv | eval services_concerned=split(services_concerned,":") | mvexpand services_concerned | rename services_concerned as service_tag]
Following is the output generated:
birthday lastname name price raining service_tag
25/05/1982 Rosenberg Joseph 1024€ communication REF4A
25/05/1982 Rosenberg Joseph 1344€ security REF4A
18/07/1981 Attali Dan 1024€ communication REF4A
18/07/1981 Attali Dan 1344€ security REF4A
12/01/1959 Salcherd David 1344€ security REF4B
07/07/1974 Sherman Gad 2745€ managment REF4C
Thanks!!
... View more