topic Re: Mapping question in Talend Studio

Mapping question

VijayTalend — Sat, 16 Nov 2024 03:41:14 GMT

I am using hierarchical mapper in talend studio. Can you please let me know the structure example of input and output file mentioned below -

I have given A1,B1,C1 as example, but it can be upto Z1 too. how to map this to get desired output as mentioned below -

Input

CO1;A1;B1;C1

CO2;A2;B2;C2

Output should be as below

NP1 CO1

NP A1

NP B1

NP C1

NP1 CO2

NP A2

NP B2

NP C2

Jaggu1992 — Fri, 03 Jan 2020 11:37:40 GMT

Hi Vijay,

Please use Tnormalize component to get the data in that order.

for example:-Think like u have two fields NAME_1,NAME_2

INPUT:-

NAME_1:A1;B1;C1

NAME_2:A2;B2;C2

OUTPUT:-

NAME_1

NAME_2:-

THANKS,

Jagan.

VijayTalend — Fri, 03 Jan 2020 13:43:23 GMT

Hi,

Thanks for your reply. I am using hierarchical mapper,so I can not use tNormalize and other components.

However, I can use functions provided by talend studio. Is it possible using talend functions mentioned in below link -

Regards

Jaggu1992 — Mon, 06 Jan 2020 05:26:32 GMT

Hi,

I don't know what is hierarchical mapper,Can you please elaborate the thing. So that I can help you.

Thanks,

Jagan.