Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have lookup file
En,English
Fr,French
IT,Italian
My main file is like
1;En,FR
2;En
3;En,FR,IT
Output expected
1;English,French
2;English
3;English,French,Italian
Any idea?
Normalise - lookup-denormalize will work but need optimal approach.
The only way is to normalise the data, perform the lookup and denormalise them again.
This is the only way - also if the amount of data a larger than your example.
BTW the title of the topic "Need Solution" does say nothing about the issue. Please consider meaningful titles like "Lookup in denormalised data". The fact you need help is obviously.
hello,
As I see, your except is just replace "en" by english, "fr" by french.
Donc, tmap is enough for you need.
Maybe you have a question about your main file which has not different number row?
Solution, you can define more than 4 colonnes and use ", " as separateur.
best wishes
