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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

count number of columns in excel

Hi there,

i have a requirement in my project where number of columns should be validated from excel file .
so any file processed should be validated against the number of columns . Data from file should not go into database if the number of columns is less or more .
How do i count the columns and take it in a variable ?

Please help!
TIA
Hachi

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi 
There is a Dynamic schema feature in Talend Enterprise subscription product, you can count the number of columns with this feature, but I don't think it is possible to do it with community version.
Best regards
Shong