Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RA6
Creator
Creator

Reading file with undefined number of column

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:

0693p00000AFcCRAA1.png

My expected out put should be like this:

0693p00000AFcD0AAL.png

Is there a way to achieve this result?

Many thanks,

Duke

Labels (3)
1 Reply
Anonymous
Not applicable

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