Challenge #64: Catch Me If You Can

[JoeM]

The solution to last week's challenge is HERE!

You have an input data that has some unknown number of fields and records as a data stream from a file that changes often. You also have a specified list of fields that you want, that also changes often. After each run of this workflow, the data will change. Hence the name of this challenge. Every time you run the workflow, the data inside the inputs will change - making it a little challenging to configure.

Hint: You will be looking at lots of Unknown fields - think dynamically!

[NicoleJohnson]

Caught ya! 🙂 This was a really fun one!

Spoiler

[AdamR]

Fun!  I wonder how many different ways people will find to solve this one.

Spoiler

My solution avoids transposing the source data.  But does need the CReW macro pack installed to run.

[patrick_digan]

Spoiler

I used a formula tool to setup the column name. I added some asterisks at the beginning of each field name so that I could tell at the end which fields were selected. 
I used a dynamic rename to change the column headings. The dynamic select chose only the field names with the asterisks. The dynamic rename then deleted the asterisks so i had my final output.

[MarqueeCrew]

@JoeM,

I think that I caught you.  I checked my solution against @patrick_digan & @AdamR.  I am very much like Digan and very little like Adam.  Adam, I think that you'll agree that the Crew macros path is a little bit much.  

Spoiler

Cheers,

Mark

[AdamR]

@MarqueeCrew I like to be different 🙂

[MarqueeCrew]

@AdamR,

You're my favorite and you know it!

See you soon!

m

[alex]

Spoiler

[Garrett]

Dynamic indeed.

Spoiler

[toddhowl]

Spoiler

That was fun, thanks!