I have a situation here, I need to read more than 50 excel files, all of them are equal in terms of columns, sheet names, and I’m able to read them via looping, however sometimes (not always) happens that for example one column is recognized by the Excel reader as String and some others as Number, ergo at the end of the loop the column type changes to the “nominal type”, I have tried several options and the one that helps me to allow all the excel reading and looping without errors is:
*NOT enforcing types in excel reader and allowing the loop to change table specs and formats, that way all excel files are read. (but sometimes have the nominal result in few columns) what I do to deal with this failure is setting a “rename node” to just change the nominal to string but seems that between executions the rename “forgets” to change the type and it fails again, so I go to the rename and just switch the type
- If I use the enforce types sometimes the reader fails, as seems that the node is not capable to force to one specific type.
I’m wondering if there is any way that after the looping, I can somehow set to specific columns to be “string” and later on I will deal with changing formats to what I need.
Thanks in advance for your support!