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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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)