topic Re: normalize component in Talend Studio

normalize component

lmit — Thu, 07 Mar 2019 09:44:24 GMT

Hi All,

I have a requirement , the input file is as below

Input file:

name;subject

a;maths,science

My output file should be

name;subject

a;maths

a;science

so I used a tnormalize component but am getting 3 rows as output instead of 2

3 rows are

name;subject

a;maths

a;,

a;science

can someone help in getting the required output

Thanks in advance

lmit

Re: normalize component

akumar2301 — Thu, 07 Mar 2019 09:52:56 GMT

Can you give screenshot of your tNormalize . I tried with your input , I got only 2 records.

Re: normalize component

manodwhb — Thu, 07 Mar 2019 10:03:23 GMT

@lmit ,check the below setting of tnormalize.

Re: normalize component

lmit — Thu, 07 Mar 2019 11:34:45 GMT

Hi All,

Thanks for your replies see my setting of tnormalize

Thanks,

lmit

Re: normalize component

manodwhb — Thu, 07 Mar 2019 11:41:30 GMT

@lmit ,if yo have not getting properly means based on the data in the column COMMDITY_CODE item separator many be different,i suggest you to open your source file in notepad++ and check the values separator in COMMDITY_CODE column and change in your tNormalizer based on that.