topic Re: Lookup dnormalize data. in Talend Studio

Lookup dnormalize data.

shrikant_kp — Fri, 15 Nov 2024 22:14:58 GMT

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.

Re: Lookup dnormalize data.

jlolling — Thu, 22 Dec 2022 19:42:10 GMT

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.

Re: Lookup dnormalize data.

jlolling — Thu, 22 Dec 2022 19:44:36 GMT

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.

Re: Lookup dnormalize data.

zjing — Thu, 05 Jan 2023 10:14:23 GMT

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