How to import complex excel file?

0
The column names change dynamically depending on the situation.(ex 202401 202402 / 202405 202406 202407 ... )   The Template Object of the existing excel importer cannot be used.   Read the uploaded excel file using the JAVA ACTION function, I want to unpivot the internal cell values and register them in the entity in order, i can write the unpivot code, but I don't know how to connect it to the mendix object.    How can I solve it?
asked
1 answers
0

The columns names are not really used, just the columnnumbers, you can create an intermediate object with more attributes than columns and read column2 -> attribute 2, column3 -> attribute 3 etc and do the unpivoting in microflows.

To find the first row, add an attribute for the rownumber (option in the importer). There you can find the dynamic column names.

 

answered