Input multiple tabs with different schema

rajputakansha

Hi,

 I have an excel file with over 80 tabs. I used "List of Sheets" macro and "Batch Macro" to import them all into alteryx.

But it looks like the column arrangement isn't same across all the sheets.

Here is a sample data set:

Name	code	date	org	plan	amount	test amount
ABC	EEC	2/4/2019	110	EZ4	$2,000.47	$ 250.64
EFG	ER120	3/12/2019	110	EZ8	$6,400.87	$ 199.00
IJK	EEC	3/26/2019	200	AR18	$8,000.00	$          -
date	name	amount	org	plan	test amount
2/18/2019	TOOR	$  1,643.89	200	TX18	$7,100.32
5/12/2019	ROTZ	$     348.98	210	TR18	$100.90
8/8/2019	WEL	5000.21	110	EZ6	$86.00
org	date	name	amount	test amount	code	plan
110	2/18/2019	ABC	$7,100.32	$      250.64	EEC	TX18
110	5/12/2019	EFG	$100.90	$      199.00	ER120	TR18
200	8/8/2019	IJK	$86.00	$               -	EEC	EZ6

 I want to get Date, Amount and Test Amount from this data set.

Is there a way to rearrange the macro output according to the column name, so that Date comes under Date and Amount comes under amount?

Thank you

Thableaus

Hi @rajputakansha 

Go to your Interface Designer properties in your batch macro and change this configuration

If the names are exactly the same, the config by name option should work.

Cheers,