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

Rename a certain column?

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

Workflow

Accepted answers

flying008

Hi, @Emmm

FYI.

录制_2024_01_08_16_02_26_779.gif

ed_hayter

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

Dynamic Rename Column.yxmd

Raj

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.

All comments

flying008

Hi, @Emmm

FYI.

录制_2024_01_08_16_02_26_779.gif

ed_hayter

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

Dynamic Rename Column.yxmd

Raj

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167