Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Considering that the fields contained in the different files might be different, you have to take a batch macro approach.
A batch macro will allow you to run a particular workflow for each one of your input files. What you have to do is first of all use a directory tool to get the Full path for each one of your files. Those files should be in the same folder, and the only thing you have to do is point that directory tool to that folder.
The directory tool will return you some fields for each one of your files; in this example I've mocked up 3 files, with the input you have provided. The field you are looking to use is the first one which is named Full Path.
This is what you should feed in the batch macro I've created for you.
Now let's see what happens inside that batch macro.
First you have an Input Data tool and some tools above it; those tools are those that will go on and dynamically change the File path every time the batch macro runs. So from the first image I have attached in this post, this macro will run for each of those file path, essentially reading all files one by one.
The for each file, you pivot the data to bring it in a long format and check if "in the class" is contained in the values column.
