This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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?
@andrewc22 I've attached a very basic workflow that will give an error if there are any extra fields in File 1 or File 2, and if the any of the data types are different for the fields in the File 1 and 2. Hopefully that will point you in the right direction.
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.