topic Re: new line separator in Talend Studio

new line separator

lmit — Mon, 29 Aug 2022 16:49:18 GMT

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

Re: new line separator

Anonymous — Tue, 30 Aug 2022 00:29:34 GMT

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

Can you explain this sentence with an example? what should be the default value in this case.

Regards

Shong

Re: new line separator

lmit — Tue, 30 Aug 2022 01:07:15 GMT

Hi @Shicong Hong , Thanks for the reply,

i mean if my date is like below

and lets say my default value is abc , then my output should be like below

Thanks,

lmit

Re: new line separator

Anonymous — Tue, 30 Aug 2022 02:58:25 GMT

@none none , have you tried tNormalize component, read the cell value a string, then use tNormalize to split the string to multiple rows.

Regards

Shong

Re: new line separator

lmit — Tue, 30 Aug 2022 05:22:21 GMT

@Shicong Hong , I tried using tnormalize but am not able to add default value .

and if I use tnormalize on date1 , it is giving 2records

while on date2, it’s giving 3 records

but for date1 col I want 3 records.

thanks,

lmit

Re: new line separator

Anonymous — Tue, 30 Aug 2022 06:36:47 GMT

after you split string the multiple rows using tNormalize, link it to a tMap, add a expression to date1 column in the output table:

row1.date1==null||row1.date1.equals("")?"default value":row1.date1

this expression assign a default value to the column if it is null or empty value.

Re: new line separator

lmit — Tue, 30 Aug 2022 07:19:03 GMT

Ya @Shicong Hong , i write the above expression i can get the null value but the 3rd record itself is not coming in the output while i normalize date1

i will be having 2 files after using normalize component one file for date1 and second file for date2

when i join these 2 files the dates are not getting correctly displayed

something like below am getting

Thanks in advance,

lmit

Re: new line separator

Anonymous — Tue, 30 Aug 2022 09:05:07 GMT

It is better to add a sequence id for each row after tNormalize, the sequence id will be the join key when you join the data back.

Re: new line separator

lmit — Wed, 31 Aug 2022 02:34:45 GMT

Hi @Shicong Hong , thanks a lot for responses

i tried with sequence id also but am not getting the 3 records for date1

for date1 2 seq id is getting generated and for date2 3 seq id

when looking up and getting 3 records but getting data either unique match or first match record

if I select all matches getting too many duplicate records and data is not getting populated correctly

thanks

lmit

Re: new line separator

Anonymous — Wed, 31 Aug 2022 02:38:45 GMT

set date2 as main flow and date1 as lookup flow, do an left outer join based on seq id.

Re: new line separator

lmit — Wed, 31 Aug 2022 13:49:02 GMT

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

Re: new line separator

lmit — Thu, 01 Sep 2022 12:12:50 GMT

Hi ,

any suggestions please

thanks in advance,

lmit