I have created a data table that returns a hierarchy of task names.
Is it possible to load this hierarchical table into another table or extract the new fields? The fields (named TaskName1 thru TaskName5) don't seem to exist apart from in the resulting table?
What I am trying to achieve is using 'TaskName1' as the grouping / top level and map this into another field in another table.
E.g. if new field name = 'Support' then 'Support' else TaskName1
I can do this in a table visualisation I just need to be able to do it on load.
I would like to help you with this request. Could you, please, attach the data that you are using (or a sample) and the code for me to understand your issue?
