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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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