Dynamic Transpose Key Field + Summary Field

bsharbo

Hello everyone.  Does anyone know how to set up a macro that would read from a file (or dataset) and then take a list (dataset , comma delimited , etc..) of the key fields that the datashould should be transposed by and dynamically alter the Tranpose tool?

The problem is I have no idea how to use an action tool to update the transpose tool to select MULTIPLE key columns... 

If possible I would like this to be a macro so that it can be used in other workflows, instead of a stand alone application... but if that's not possible I will take a stand alone application as well :-)

I have included a very simple workflow that shows how I was able to do this with choosing One Key field using a text box input.... I would like to extend this problem to multiple key fields, and also make it so it is inside a macro and the users don't need to prompt on it! 

Let me nkow if my question was not clear and thank you!

Compare Proc.yxzp

jdunkerley79

Nope didn't think trying to be difficult - just a deep bit of alteryx to expain. The clearer I can make the better, and helping to give understanding is what the community is great for.

The way I tackled this problem was set up what I wanted first without a macro.

Save the workflow.

Open in your favourite decent text editor (I like VS Code or Atom) as Alteryx workflows are just Xml.

Find the node you want to control and hopefully it is easy to read. Normally is as Ned and his team do a great job.

Normally I would expect to be poking at the Inner Xml of a tool's configuration as changing the structure (i.e. OuterXml) would normally break the tool, or at least muck the configuration up. 

I found this one of the hardest area to get started in, but is also one of the most powerful features. I cheated and used some of the great @chris_love brain when I started.