Data Mapping

[SouravAudi]

Hi,

I have some fixed Columns in Excel and the columns will remain same but i need to change the data source each time. How I can upload my Column names present in the excel in Alteryx and map the columns with the data source and continue the same same workflow.

[Joe_Lipski]

Hi @SouravAudi, 

Here are a few potential options for you:

• Use Union tools to 'stack' data ontop of eachother
• Use a wildcard (*) in your file path to read in multiple files of the same format and structure
• Use a dynamic rename tool to rename headers based on postiion
• Use a Directory tool and Dynamic Input tool to read in new files based on file metadata (e.g. data modified)
• Use a batch macro to read in multiple files of different field types: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

If you can share files or screenshots, I can try to point you to a recommended approach.

Thanks,

Joe

[SouravAudi]

Thanks for your Answer.

Let me give You an Example: 

I am doing a sales calculation I have prepared a excel format with Columns 'Product Id', 'Product Name', 'Unit_price' , 'unit ordered' and it has no values just column names.

Now when I have connect my Alteryx designer with Oracle database, I have coulmn names such as 'P_ID','P_name', 'U_P', and 'Unit_O' .

So I need to map the Columns that i have prepared in excel with the columns in the oracle.

And also if I connect to any other data source how can I  map with the columns that i have created in excel with the new data source.

[Joe_Lipski]

I think you would want to use a union tool with both inputs going into it and auto-configure by position or manually configure.

Apologies I'm not at my laptop right now, so cannot share an example.

[Joe_Lipski]

Hi @SouravAudi 

Here's an example attached - You will just need to replace the text inputs with your real inputs.

Please let me know if this helps.