Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!

[Hi2023]

Hi, 

inside the macro -where you have the file 1 and 3, which files are these? I have to do same but w 30+ files but I only need specific columns from some of those sheets

[FinnCharlton]

Spoiler

[Hi2023]

The workflow didnt pulll up -missing macros :/

[ahsanaali]

Spoiler

[karlhansen]

Spoiler

Not much to see here -- I made a couple of tweaks.

Bonus:  I would advise my colleague run the 60 data files through an Alteryx preprocessor workflow that would ensure column order.

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[kristiadiuisan]

Batch Macro and Directory are keys. On a side note, please download File1 to File4 on your own.

[sabellatjang]

Spoiler

[leonhekkert]

Used a batch macro for this while stating that order of columns might be different during batches.

Spoiler

[CeliaC_Silje]

Spoiler

Workflow:


Macro: