Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Get Names of Tools, Join Information, & Fields Passed Between

Highlighted
8 - Asteroid

Is there a method that would provide the name/type of the tool(s) being used, specific information like join or left out join the fields they are joined on, what fields are being passed on to the next tool... what fields are falling out (deselected).

 

Thanks,

 

Puff

Highlighted
14 - Magnetar

You can get a lot out of loading the alteryx workflow file into Alteryx as an XML.

 

I used the Parse XML macro in the attached example.

 

Key thing is to load the workflow file as a csv with \0 set as delimiter and uncheck first row contains field names.

 

The workflow file I'm reading in this example is the regex split dates to rows file.

 

Parse XML macro install also attached.

 

DavidP_0-1583315090281.png

 

 

 

Highlighted
8 - Asteroid

I appreciate the response back and examples for guidance.  I will take a look at it and let you know how it turns out. 

 

Thanks, 

 

Puff

Highlighted
8 - Asteroid

I finally got to a point where I could try this.

 

On the load alteryx workflow as xml.... I am getting a (3) "the entry point is invalid" error.

 

Puff

Highlighted
14 - Magnetar

Which tool is the error on? Make sure you have a look at how the Input Data tool is configured in the example I attached.

 

file type: csv 

delimeter: \0

uncheck 1st row contains headers

 

The idea is that you load the xml file into a column called Field1 and then set this as the field that the parse xml macro parses.

Highlighted
8 - Asteroid

DavidP,

 

I appreciate the response back.

 

load alteryx workflow as xml is where I am getting the error.

 

I have this exactly

"file type: csv 

delimeter: \0

uncheck 1st row contains headers"

 

I can see Field1 populated in the Input tool.

"The idea is that you load the xml file into a column called Field1"

 

The error I described is in the macro parse tool right after that Input tool.

 

Just the suggestion to load the workflow file itself has helped me tremendously.... never even thought to do it. Regardless of if I can get this to work, your suggestion has already opened up my potentials.

 

Thanks,

 

Puff

Highlighted
14 - Magnetar

Would you be able to attach your workflow?

Highlighted
8 - Asteroid

The one I was testing has sensitive data in it.

 

I will try it against another and let you know.

 

Thanks,

 

Puff

8 - Asteroid

@DavidP 

 

Chalk it up to user error.

 

I re downloaded your 3 attachments, put the Parser in a macro file 

 

added my yxmd to load alteryx workflow as xml 

 

set the setting per your instruction

 

hit run

 

Bam!  4 columns of xml-less love.

 

Of course after the first 7 attempts & failures I spent a fair amount of time starring at the data from an excel output to digest the structure.

 

This gets me closer to what I want to achieve as an end result, which is basically a left to right tabular version of the workflow in the order it runs so I can identify what ties to what, how, fields used, fields created, fields changed, etc etc etc.

 

Again... thanks you for sticking with me as long as you did.  I realize your time is valuable.

 

Puff 

Highlighted
14 - Magnetar

Hi Puff,

 

Your reply made me smile - you're very welcome, glad you got it working in the end.

 

Staring at the data (in an ugly format) from time to time is not a bad thing! It makes you appreciate the power of Alteryx!

 

Reformatting the data to a left to right format - sounds like a great opportunity to flex your CrossTab tool muscles!

 

Good luck and let the Community know if you need any help! That's what we're here for!

Labels