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

[jamielaird]

Well that wasn't much fun...! But I won't be forgetting about "auto configure by name" any time soon.

Spoiler

[JosephSerpis]

Challenger Completed 

[DavidP]

So I finally bit the bullet wrote my first batch macro! One of those things I've always been putting off. As everyone says, writing a macro is actually pretty straight forward, EXCEPT, I couldn't for the life of me figure out why my macro only returns one line of data! After rewriting it countless times I finally consulted the community for help and found out that I have to add a BROWSE tool!!!!

As they say, the harder the lesson the better it sticks...

For my macro solution I configured the Input tool to return a list of sheet names, which I then used to build a new filepath and fed it to a dynamic input tool.

[danilang]

My solution

Getting the proper configuration for the macro was the key

Spoiler

Dan

[kelly_gilbert]

Spoiler

1 - It took me a while to remember where to change the output setting for the batch macro (to allow different output schemas)!
2 - TIL that the Dynamic Input tool appears to import the first sheet, if a specific sheet is not provided. So, I could have simplified my macro by just using the dynamic input (without getting the list of sheet names, picking the first, then concatenating that to the file path).

[PhilipMannering]

My solution uses a batch macro simliar to most peoples..

Spoiler

WorkflowBatch Macro

[JoBen]

Cheers!

Spoiler

I went the batch macro path. Here is what my macro looks like. 

[pasccout]

Here is my solution... lost a lot of time fighting with the action tool... 

[PrivateStorm]

My solution to challenge #118 is attached.

[jssandom]

My 100th challenge!!