nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

File2 has a different number of fields than the 1st file in the set and will be skipped

Rajinikanth

Hi,

Thanks in Advance!

I'm new to Alteryx and I'm trying to load multiple files having different schema to multiple SQL tables using batch macro & dynamic input. But only 1 file is read and other files are skipped.

Example : I have 2 files "File1" & "File2" and these 2 files should be loaded to 2 different SQL tables when i give the folder path to directory tool.

File 1:

SNO	Name	Designation
1	Mark	Manager
2	Tim	Senior
3	Jon	Staff

File 2:

SNO	Name	Department	Pay
1	Mark1	ABC	XX
2	Tim1	XYZ	XY
3	Jhon1	ADF	XZ

Method i used is :

Calling Macro.PNG

Can anyone help in getting this done. With an example.

Thanks!

Batch Macro

Dynamic Processing

Accepted answers

randreag

hi @Rajinikanth

If you use dynamic input for this , you are always going to have problems with the fields

You need to receive in the macro the file name, without using the dynamic input, in the same macro you can add a insert in to the table, sending the name dynamically

i hope it helps

Let me know if you have more questions

Rajinikanth

I Changed the Macro WF by adding "Output tool" directly in macro instead of Macro out and Called this Macro in the Main WF which solved the issue.

Thanks!

All comments

randreag

hi @Rajinikanth

If you use dynamic input for this , you are always going to have problems with the fields

You need to receive in the macro the file name, without using the dynamic input, in the same macro you can add a insert in to the table, sending the name dynamically

i hope it helps

Let me know if you have more questions

Rajinikanth

Thank you !

I now removed dynamic input tool and now the different schema issue is not shown, but when i load data to SQL tables. Both the tables have columns from both the files. But it the table should ideally have column names that are present in the source input file.