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

[praveen4dglobl]

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?

[schulz_d]

Hey,

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

[praveen4dglobl]

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

[praveen4dglobl]

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