Iterative Macro Help

I am having trouble with iterative macros.

I need to build an iterative macro in order to run through 2 .txt files to ensure the files have the same fields/schema, and if they do not provide an error message and if they do continue running the workflow.

So what I need help with is, building the iterative macro that can take in any user input and go through the fields in order to make sure both datasets have the same schema

Does this make sense or is there any easier way to accomplish this? Thanks!

Datasets

Input

Error Message

Macros

Interface Tools

Iterative Macro

Accepted answers

pedrodrfaria

@andrewc22 Inside of this package you will find a batch macro to open the txt files, after this you can set up the logic that you need to compare it.

Pedro.

Iterative Macro Help.yxzp

All comments

markcurry

Hi @andrewc22

Have you looked at the Crew macros? There is an Expect Equal macro that will compare two files for you. Here's a link..

http://www.chaosreignswithin.com/p/macros.html

andrewc22

I have, I need the macro to extract the field names so I can then run a filter to see if both files have the same fields. When I used the CReW macro, it doesn't allow me to run the rest of the workflow?

pedrodrfaria

Hi @andrewc22

You do not need to have a iterative macro, you can have a batch macro (much easier to build) and make it open both txt files, and set up a conditional based on errors to see if they have the same schema or not. Should be super simple and much easier than a iterative macro.

Pedro.

andrewc22

Would this method keep all the data in both files and if they have the same schema move along the rest of the workflow?

After I have assured the schema is the same, I have to compare the key columns.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703