Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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 -
https://help.talend.com/reader/njNNGkCowThcKR6notunrw/xTil1KUpAzKxHkybPkM3WQ
Regards
Hi,
I don't know what is hierarchical mapper,Can you please elaborate the thing. So that I can help you.
Thanks,
Jagan.