Field mapping

Hello,

I am trying to consolidate some information from multiple Clients, unfortunately the files are not in the standard format, Therefore I have created a Column mapping table using excel for each client (refer the snapshot). How can we map the input fields in Alteryx using the mapping table to get the desired output?

Thanks in advance for your support Field mapping table.JPG

Field mapping table.JPG

Input

Accepted answers

ChrisTX

Try the Dynamic Rename tool, under the Developer tab. Or just search for it using the top-right search bar. Open the example workflow with a right-click, or directly from the search results.

You can import your client file, and use your mapping table with the Dynamic Rename tool to change the field names to your Desired Field Name.

Chris

Karthick_sankar

ChrisTX

I tried but it didn't work as expected, Could you share a sample workflow please?

Sorry I am just a beginner in Alteryx.

Thanks a lot!

ImadZidan

Hello,

I see what you mean. if I understand you correctly, you will have a a different file for each client. each client will have different field name. you are trying to standardize or unify the field name across all clients. very good idea. So, you created a mapping table to include field names for each client. First, I recommend that you include all the fields that you want to include in your mapping table even if not dynamic. this is fruitful for any future changes. Please see attached. test it and ensure it works with different combinations.

Using dynamic rename as suggested is the way, but first you need to determine which client and what fields before doing so. Check workflow and it should give you an idea.

I hope this helps.

Dynamic Fields Names.yxmd

All comments

ChrisTX

Try the Dynamic Rename tool, under the Developer tab. Or just search for it using the top-right search bar. Open the example workflow with a right-click, or directly from the search results.

You can import your client file, and use your mapping table with the Dynamic Rename tool to change the field names to your Desired Field Name.

Chris

Karthick_sankar

ChrisTX

I tried but it didn't work as expected, Could you share a sample workflow please?

Sorry I am just a beginner in Alteryx.

Thanks a lot!

Karthick_sankar

Thanks a lot! your suggestion works as expected

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703