Re: Mapping question - Qlik Community

VijayTalend · ‎2020-01-03

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 · ‎2020-01-03

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

A1

B1

C1

NAME_2:-

A2

B2

C2

THANKS,

Jagan.

VijayTalend · ‎2020-01-03

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 · ‎2020-01-06

Hi,

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

Thanks,

Jagan.

Mapping question