Using Directory to Create a Macro to Fix Error "different schema"

Hi,

I am a newbie to macro and I have been looking in the site about a directory converting to input macro however I can't find one to give me a solution. I have these tools as shown below where I have encountering problem "FileInfoReport" has a different schema". Can you please help how to create a macro or a sample solution?

Hoping for your assistance on my inquiry.

thanks

Kamen

Workflow

Macros

Common Use Cases

Interface Tools

Accepted answers

All comments

Felipe_Ribeir0

Hi @KamenRider

You can use the attached one, it came from this topic: The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten

Batch Input (1).yxzp

gyang3

@KamenRider This alternative may be helpful as well. This macro will allow you to fee multiple different file types and different schemas all at once.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynamic-Dynamic-Input/td-p/329286

KamenRider

Hi @Felipe_Ribeir0 ,and everyone else to help.

I have tried the batch input however I am still encountering the same error of invalid schema. See screenshots.

In line to upatevalue tool, can you please help me how can I update it. Can you please give me a sample? I have multiple excel files to read. Should I place full path + *.xlsx in the input file and the update file check the replace a specific string and type the name of the other file?

Thanks,

Kamen

Felipe_Ribeir0

Hi @KamenRider

The attached file already is an example of a batch macro fully configured to input.xlsx files.

Just change the Directory Tool input to point to the folder location of your files, see if name of the sheet of the files that you want to open is "Sheet1". If it is not, change the name in the formula tool.

This should work, if it does not work, please send us prints of the error message.

BatchMacroExample.yxzp

KamenRider

Hi @Felipe_Ribeir0

Question.. do I need to change something in the macro files?

1. Do I need to input something here?

2. This is automatic right?

3. Do I need to tick this or leave this blank?

4. I'm using a directory tool to read all excel files, do i need to change something in this part?

Looking forward for your clarifications.

Thanks,

Kamen

Felipe_Ribeir0

Hi @KamenRider

For .xlsx files you do not need to change anything. These values that you highlighted will be replaced by your main workflow.

Felipe_Ribeir0

Hi @KamenRider

It worked?

KamenRider

@Felipe_Ribeir0

Sorry for late reply. For some how, I am still getting an error of invalid schema. I can't understand the work around of macro about it is being created and done. I am going to check more on this and will be back for questions. Feel free to share more solutions.

Thanks,

Kamen

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280