Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello everyone,
I want to replicate the path() dax function using visual recipes in Dataiku.
For example, I have this source table :
ID | Parent_ID |
A | B |
B | G |
C | A |
D | C |
E | F |
F | A |
G | B |
I want to create a new Path column that returns a delimited text string with the identifiers of all the parents of the current identifier, starting with the oldest and continuing until current :
ID | Parent_ID | Path |
A | B | H|G|B|A |
B | G | H|G|B |
C | A | H|G|B|A|C |
D | C | H|G|B|A|C|D |
E | F | H|G|B|A|F|E |
F | A | H|G|B|A|F |
G | H | H|G |
I tried to use a python recipe but I apparently have a memory problem. I don't know if it can be achieved through visual recipes and formulas.
Thank you for the help.
Hi @riri92,