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

[rachel_lynch]

Spoiler

 

[ed_hayter]

Spoiler

Batch Macro Use Case

Use the Control Parameter to Update the file path - union data auto configure by name.

[DaisukeTsuchiya]

Spoiler

 

[gawa]

DOne

[Sebastian_Chaieb2]

One of the best usage of Batch macro 

Spoiler

Batch macro

  

[Hammad_Rashid]

[RWvanLeeuwen]

retaking this to prep for expert exam

proposed solution

Spoiler

bonus question

Spoiler

another Control Parameter tool combined with an Input Data tool as to influence the file type for data input, meaning the Dynamic Input tool would not be used then

[olga_strubbe]

 A neat challenge, thank you, @EddieW  - true to real-life use case.

My workflow: 

My macro:  please update macro input with your file path  - I entered a placeholder in the attachment - sorry, not able to share mine due to security.  Thanks!

[Tgigs]

My solution attached.

Unfortunately could not get file 3 to load, because it says that the schema changed. Could not figure out why because all of the columns are the same. In order for the solution to work all the file schemas need to be the same.

[lynnesonneyrsm]

I use this all the time!