Create multiple row with carriage return cell value in excel

Parikhharshal — Sat, 16 Nov 2024 01:49:53 GMT

Hi Talend experts

Could you please help me with this unique problem of reading data from excel and streamlining it to make it readable?

I have got data in excel like this having carriage return as a searator to add new value to cell:

student_cours Unit

123_mktg 2020 abc (90) PASS

2020 xyz (Enr)

2020 efg (Enr)

2020 erp (Enr)

I want to make it like this:

123_mktg 2020 abc (90) PASS

123_mktg 2020 xyz (Enr)

123_mktg 2020 erp (Enr)

How can I do it from excel?

Thanks

Harshal.

Re: Create multiple row with carriage return cell value in excel

Anonymous — Wed, 22 Jul 2020 09:25:04 GMT

Can you attach an example Excel file? I want to see what's the output if I use tFileInputExcel component to extract the data.

Regards

Shong