Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

normalize component

Highlighted
Seven Stars

normalize component

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


Accepted Solutions
Highlighted
Moderator

Re: normalize component

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post


All Replies
Highlighted
Eleven Stars

Re: normalize component

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

Regards
Abhishek KUMAR
Highlighted
Moderator

Re: normalize component

@lmit ,check the below setting of tnormalize.Untitled.pngUntitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Seven Stars

Re: normalize component

Hi All,

 

 

Thanks for your replies see my setting of tnormalize

 

tnormalize_records.PNG

Thanks,

lmit

Highlighted
Moderator

Re: normalize component

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog