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

[rohit782192]

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

[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):

<Node ToolID="1">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">

<Node ToolID="2">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">

<Node ToolID="3">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">

<Node ToolID="4">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">

<Node ToolID="7">
<GuiSettings>
<Position x="702" y="198" />
</GuiSettings>
<Properties>
<Configuration />
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings Macro="TestMacros\CReW_ExpectZeroRecords.yxmc" />
</Node>

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:

<Node ToolID="1">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">

<Node ToolID="2">
<GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">

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?

<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="2" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="11" Connection="Input" />
</Connection>

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.

Can you provide sample input for this issue you mentioned:

  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 

Chris