Hi , It is Difficult to Understand the Connection that is being Extracted via Alteryx. Is there any way we can include Tool Name against the same and also their Properties from the Node. This is the Dummy XML Output i am providing to simple Understand . I want to add Tool Details and their properties from Node. Origin_ToolIDOrigin_ConnectionDestination_ToolIDDestination_Connectionname1Output4Input 1Output20Input8 3Left6Input#13Join6Input#23Right7Input#13Join7Input#23Left8Input#13Join8Input#23Right8Input#34Output10Input2 4Output18Input 5Output11Input2 5Output19Input 6Output15Input 7Output17Input 8Output16Input 10Output263Left 11Output263Right 15Output12Input 16Output13Input 17Output14Input 20Output922Input 21Output923Input

How can we relate Tool id from the Node in the Connection of Alteryx XML that is Extracted

Hi ,

It is Difficult to Understand the Connection that is being Extracted via Alteryx. Is there any way we can include Tool Name against the same and also their Properties from the Node.

This is the Dummy XML Output i am providing to simple Understand . I want to add Tool Details and their properties from Node.

Origin_ToolID	Origin_Connection	Destination_ToolID	Destination_Connection	name
1	Output	4	Input
1	Output	20	Input8
3	Left	6	Input	#1
3	Join	6	Input	#2
3	Right	7	Input	#1
3	Join	7	Input	#2
3	Left	8	Input	#1
3	Join	8	Input	#2
3	Right	8	Input	#3
4	Output	10	Input2
4	Output	18	Input
5	Output	11	Input2
5	Output	19	Input
6	Output	15	Input
7	Output	17	Input
8	Output	16	Input
10	Output26	3	Left
11	Output26	3	Right
15	Output	12	Input
16	Output	13	Input
17	Output	14	Input
20	Output9	22	Input
21	Output9	23	Input

Workflow

Accepted answers

All comments

ChrisTX

By "Properties", do you mean the configuration for each tool?

For Tool Name, you'd probably need a mapping file to translate something like "BrowseV2" to "Browse Tool". I haven't seen anyone post a mapping like that.

And macros don't have any text on the line for GuiSettings.

Example from a workflow's XML (YXMD file):

Chris

rohit782192

I need to Extract Plugin Details for the same for Each tool

ChrisTX

Are you asking how to get data from one row joined to the row below? Like

Output:

ToolId	Tool Palette	Tool Name (Plugin)
1	Base	DbFileInput
2	Spatial	Summarize

using this Input data:

Chris

rohit782192

Hi ,

I am aware of Extracting the data and i am the Expert in the same.

My Expectation is Formatting Output.

This is just a Sample Architecture i am providing.

Origin_ToolID	Origin_Connection	Tool Name	Tool Extract	Destination_ToolID	Destination_Connection	Tool Name	name
1	Output	DBInput		4	Input	AlteryxSelect
1	Output	Select	Roll No : True	20	Input8	Summarie
3	Left	Formula	Formula Detais	6	Input	AlteryxSelect	#1
3	Join	Union		6	Input	AlteryxSelect	#2

ChrisTX

When you say "My Expectation is Formatting Output."

what do you need help with? I'm not understanding exactly where you need help.

rohit782192

I am unable to relate or Join connection and Node tool id together.

When union it is coming a Null and when Join by row I'd it is giving different output

ChrisTX

Guessing you've already seen the separate section of the XML for Connections?

So after parsing you would end up with something like this:

Origin Tool ID	Destination Tool ID
1	2
1	11

And each Tool Id from the Connections section should exist in one of the Node sections of the XML.

Chris

rohit782192

Yes,

I have already Seen the same. I am also getting the Output from Connection.

I want to map the Connection to Tool iD and Plugin .

ChrisTX

For each Tool Id you find in a Node, you should be able to join to a Tool Id from the Connections. But if a Tool does not have any Connections, I won't have a record in the Connections section.