importing files with different columns into one file

[Malek22]

Hello dears, I'm trying to import multiple excel files in one file in alteryx  by choosing a directory then adding the input dynamic after that I choose a file on the input data source template , choose the read list of data source field :  FullPath and action is change file/table name 

 I usually got an error because the data types and the columns are not aligned with each other with the error message below : 

[randreag]

Hi @Malek22 

Yes when you have differences in your files the method that youar using doesn't work

I attached here a macro where you have to send the fullpath of the directory. 

I hope it helps 

[pedrodrfaria]

Hi @Malek22 

I have attached a package with the workflow below and the Macro that opens files with different schemas at the same time. See below for an example:

In the example above I have 3 different dummy files with different schemas. I also attached them for educational purposes.

This one is for xlsx files, please let me know if you are working with different files. The process to create one is super simple.

Pedro.

[Malek22]

Hi @randreag 

 It doesn't work with me , I have added directory file, then file path plus the sheets and the macro with my files , the issue appears with the dynamic input again  

[Malek22]

Hi @pedrodrfaria  , 

 I have proceed with what you have done and it doesn't work with the dynamic input it showing to me the same error 

[randreag]

Hi @Malek22 

You have to replace the dynamic input with the macro.

You can't use it because it has problems with different schemas

[pedrodrfaria]

Hi @Malek22 

You do not need to use the dynamic input. Update the workflow I sent with the correct path and the correct sheet name and it should work. You will not need to use the dynamic input at all.

Pedro.

[Malek22]

@randreag @pedrodrfaria  

 Many thanks for your support this worked with me, but how I can add the time and date of the report creation as what I used to do in the dynamic input tool ? 

 Thank you  

[pedrodrfaria]

Hi @Malek22 

I believe this is what you are looking for?

Pedro.

[Malek22]

HI @pedrodrfaria , 

 Thank you for sharing this with me, 

 Unfortunately, couldn't open the workflow due to the old version I'm using, so could you please let me know what you have filled in the parameters in find and replace tool ? Thanks again