Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have a csv file as input and i need to extract clients informations from it.
The information of each client data is between a block of lines and the problem is that there is no defined schema/number of columns/separator.
The only line that separate each client block information is the line below:
0------------------------------------------------------ END OF REPORT 4251 ------------------------------------------------------
Here is an example of a block of information for one customer:
My expected out put should be like this:
Is there a way to achieve this result?
Many thanks,
Duke
Hello,
With talend subscription solution, here is a dynamic schema feature which allows you to design schema with an unknown column structure (unknown name and number of columns).
Best regards
Sabrina