Rename fields in any table according to the Common Data Model (CDM)

[PaulJasonMackjoo]

Hi all,

I need help to create a workflow to rename any table's fields (e.g. let's say Stock transaction table fields) according to field names found in table from the Common Data Model (CDM). I know there maybe many ways to achieve this but I want to get the most efficient one. Below is one attempt.

Step 1: Input CDM file

Step 2: Select fields required from the CDM (Based on what is available in Client table)

Step 3: Input Client table

Step 4: Select fields required from the Client table

Step 5: Use Dynamic rename tool to transfer fields names from CDM to that of the client table

Grateful if you can please help to find a more efficient way.

Thanks.

Jason

[gabrielvilella]

I don't see anything wrong with your approach. This is how it is supposed to be done. I cannot provide any more insights as I am not seeing the data. Please mention if you are facing any issues. 

[PaulJasonMackjoo]

@gabrielvilella Thanks for your response. Appreciate.

In fact, I am not facing issues. I am looking for ways/tools which can improve the workflow.