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 |
Record ID will be common in both the place. That the reason i have introduce Record id.
Do you have a better approach?
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.
Can you try including Toolname for Destination tool Id
Did you get a chance to look on the same.?