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

[resolved] tFileInputExcel - number of columns limited?

Hello there!
I am using metadata for tFileInputExcel, where I need to process xlsx file with many columns. Namely, around 90 of them.
Everything works perfectly if I work with smaller set of columns when specifying first and last column in metadata. 
But, when I set 7 as  start column and any number greater that 61 as end column in "Add Excel File" dialog, there is a following error which prevents me from proceeding:
" Last column parameter error. Bigger than schmea columns size" - literally, with this "schmea" typo.
Does this mean that this component has a limitation to number of columns that can be processed or this is a bug?
Is there a workaround for this - I need to process ALL the columns.
Thank you.
Cheers,
Labels (2)
10 Replies
Ounga
Contributor
Contributor

@Reinert Roux​ Thanks, that was very helpfull (4 years later)