new line separator

[lmit]

Hi All,

I have a input file like below

the data in 2 columns are single row

my requirement is - in date1 col we have 2 dates and date2 col has 3 dates

so my output should be like below

The records in the cell are separated by new line (\n)the <default value> is based on date 2 col as its having 3 dates entries.

If date1 col has one date then the default values should in 2 entries

Anyone can please help me to how to achieve in talend

Thanks in advance,

lmit

[lmit]

Hi @Shicong Hong​ ,i tried as you suggested but still the 3rd record is missing

after normalize component the 2 files look like

 

after lookup with left outer join the result is like

 

any other suggestions would really appreciate

thanks in advance,

lmit

[lmit]

Hi ,

any suggestions please

thanks in advance,

lmit