My Excel Reader losses it's transformation settings when i browse the same file with same columns from another folder. How to overcome this?

My Excel Reader node transformation settings gets reset after browsing to a new file with same columns and same sheet name.

I need the same transformation even if i change the file with same column name
How to fix this?


what you can do as a workaround is to pass the path of the file via a flow variable. With that all the settings stay the same

Best regards


Thanks!!..Can you please tell how to pass the path of the file via flow variable…It would be helpful

Thanks for your reply…I did it…Now my transformation settings is not getting reset.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.