Rename a certain column?

[Emmm]

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:

• Source document 1: at column #11, column name is "invoice date";
• Source document 2: at column #11, column name is "invoice rec'd date". 

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!!

[flying008 · Accepted solution]

Hi, @Emmm 

FYI.

[ed_hayter · Accepted 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

[Raj · Accepted solution]

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.

[Emmm]

Thank you Raj!!!!

[Emmm]

Thank you so much @flying008 for your detail explanation!!!!

[Emmm]

Thank you so much @ed_hayter for your detailed demonstration!!!!