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

Dynamic Schemas in Talend Open Studio - Limit of 53 columns

Hello,
I used the solution described in this post ()
 to load an excel file with dynamic schema. It was working until the total number of columns exceed 53 columns.
I want to extract 53 columns in my excel file but when an extra column is added between theses 53 columns and not after the last one, I get this error :
Exception in component tMap_4
java.lang.NullPointerException
    at java.lang.Class.searchFields(Unknown Source)
    at java.lang.Class.getField0(Unknown Source)
    at java.lang.Class.getField(Unknown Source)
    E.tFileInputExcel_5Process(E.java:5747)
    E.tFileInputExcel_3Process(E.java:2885)
    E.tFileList_1Process(E.java:1091)
    E.tFileDelete_1Process(E.java:835)
    E.runJobInTOS(E.java:15239)
    E.main(E.java:14961).
I tried to fix the initial capacity of hashmap in the tsetGlobalVar without success (new HashMap<String, String>(100000) ).
Do you know why? Thank you.
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi,
Could you please give us your related forum link? Are you using custom component with dynamic schema in Talend Open Studio?
Best regards
Sabrina