Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
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