Dear all,
I'm wondering how to rename a certain column?
I have two different source documents, one may be used randomly at hoc. What is different about these two source documents is that:
I need to rename "invoice rec'd date" to "invoice date" if source document 2 is applied. Not sure how to make the workflow work for both source documents?
I have tried Select/ Dynamic Select / Dynamic Rename, but did not work :(
Thank you all for helping!!
Solved! Go to Solution.
If its just one column a conditional formula in dynamic rename should work. if there are more columns i'd recommend a mapping table and renaming from that mapping table.
For just one column pic 1 is with the input that doesnt need renaming - nothing changes, pic two has the rename and reflects source document 2:
The union is just so we can have both inputs flow through the same tool and reflect how it operates on the different inputs
According to me dynamic rename tool is perfect for your requirement.
fi there are issues you can add sample workflow we can debug it for you.
Thank you Raj!!!!
Thank you so much @flying008 for your detail explanation!!!!
Thank you so much @ed_hayter for your detailed demonstration!!!!