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

[rohit782192]

Please refer the attached sample workflow where i am facing issue along with XML File.

[ChrisTX]

Can you help me understand why you are joining on RecordID?

See attached workflow.

Chris

[rohit782192]

Record ID will be common in both the place. That the reason i have introduce Record id.

Do you have a better approach?

[ChrisTX]

Generally, Record ID is not a good field to use for a Join.  Because it doesn't not accurately reflect any relationship between fields.

Did you see the workflow I posted?   I think it has a good Join example.

[rohit782192]

Can you try including Toolname for Destination tool Id

[rohit782192]

Did you get a chance to look on the same.?