normalize component

[lmit]

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

[akumar2301]

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

[manodwhb]

@lmit ,check the below setting of tnormalize.

[lmit]

Hi All,

Thanks for your replies see my setting of tnormalize

Thanks,

lmit

[manodwhb · Accepted solution]

@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.