Different Schema

Hi,

I have created the workflow below, which is collating all the tabs called mismatches in the spreadsheets in a certain folder and then it is taking a few columns out and then removing anything that = null in the column corrective action.

It is then doing the same for the Negative tab, but also taking anything out that = progression.

The workflow when ran is saying 'different schema' - however, I know that the files are the same, as to test it I have saved the same file 4 times and just changed the values in the corrective action column.

I have looked at guidance and it is to create a batch macro, however I can't work out what settings I have done wrong as it just says "ToolID:4" has an error and the file is not a known format.

I think as I need it to look at the different tabs as well as the different spreadsheets, a directory tool isn't the correct one to attach to the batch macro.

I hope this all makes sense, I have attached some sample data and my first workflow without the macro.

Thank you so much.

Input

Error Message

Best Practices

Batch Macro

Accepted answers

mceleavey

Hi @ALLSEBS01 ,

as @davidskaife pointed out you are trying to load different files with different schemas. I built a couple of tools to get around this, and you can see a discussion of how to use them at the following thread:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-multiple-Excel-files-with-multiple-sheets-with-same-layout/td-p/769498

I hope this helps,

All comments

ALLSEBS01

Attached is my workflow with Macro.

davidskaife

Hi @ALLSEBS01

Alteryx will not like it when there are any differences between the files, and this includes datatypes - in Sample Accruals 1 it's identifying the field Corrective Action as a V_String, but in the other three files it's identifying that field as a Double, hence throwing the warning and not bringing the data in.

In this instance you will have to create a batch macro to process the files

mceleavey

Hi @ALLSEBS01 ,

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Input-multiple-Excel-files-with-multiple-sheets-with-same-layout/td-p/769498

I hope this helps,

binu_acs

@ALLSEBS01 in your batch macro change the action tool setting to below and try again

davidskaife

Hi @ALLSEBS01

Looking at your macro you're almost there; as well as doing what @binu_acs suggested you will also need to add the sheet name to the fullpath for it to work correctly using a Formula tool

[FullPath]+"|Mismatches$"

If you have a read through the link that @mceleavey provided it goes into more detail, and there are pre-built macros for you to use as well!

ALLSEBS01

Thank you!

This has worked for me!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703