Data Mapping

Question

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 · Answer

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.

Union Example.yxmd

Joe_Lipski · Answer

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.

SouravAudi · Answer

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.