Forum Discussion
Unroll data from self-referencing table
Hi arbr
Thanks for reaching out to us.
Could you please provide more details according to the picture below,
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xiaotang !
In this example the outcome of rule2 would be thing3, thing2 and thing1. The outcome of rule3 would be exactly the same as rule2 which obviously doesn't make any sense, but I tried for this example to create something the most simple possible while including enough to understand my issue.
In my real dataset I have hundreds of rules with thousands of "things" with lots of imbrication...
Thanks to you I realized the last table I inserted is wrong, so that would be the real end-goal visualization :
rule.name | thing.name |
rule1 | thing1 |
rule1 | thing2 |
rule2 | thing3 |
rule2 | thing2 |
rule2 | thing1 |
rule3 | thing3 |
rule3 | thing2 |
| rule3 | thing1 |
Regards