Hi @EnriqueS and @emilyzhu Thank you for your answer. I do not have Data Brew or Glue Studio, and I understand that it is possible when you can make a pre-processing. I found a simple solution to create it using the path column and split function in our Dataset (Calculated field for each level) . However, I cannot replace our numbers with the respective name based on my columns (cod and name). My “solution” is available in the following image.
I created 4 levels:
Level 1 = parseInt(split({Portfolio Id Path},“/”,1))
Level 2 = parseInt(split({Portfolio Id Path},“/”,2))
Level 3 = parseInt(split({Portfolio Id Path},“/”,3))
Level 4 = parseInt(split({Portfolio Id Path},“/”,4))
What do I need now? Replace my cod in each column I’ve created to use the respective name in our name column.
Any thoughts?