Hi Everyone!
I am having some trouble automatically deriving three fields that I need for properly setting up a Family Tree in Tableau.
Background:
I am trying to create a Family Tree in Tableau, and need to prep the incoming data for it. I am following a tutorial on YouTube on how to create this view in Tableau, however I need to prep the incoming data in Alteryx.
Problem:
In the tutorial, you will see three fields (START_NODE_ID, END_NODE_ID, and PATH) that I am trying to derive automatically in Alteryx.
The person recording the tutorial states that he derived these fields using Python, but could also be done in Alteryx easily. However, the person that made the tutorial is not able to share the Python code. I have tried to recreate these fields in Alteryx, but I am having trouble doing so.
Link to YouTube Tutorial:
https://youtu.be/B0IxDH8Cm80?t=118
The YouTube Presenter explains what each field from 1:58 - 5:50 in the video.
The Input:
Desired Output:
Attachments:
Thank you all for your great help and support!