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: 
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