Forum Discussion

EmpMsgAEG's avatar
EmpMsgAEG
New Member
4 years ago

Obsolete Hierarchie cannot be dismissed

Hi Guys   I have the following challenge. I'm getting the data via REST from our DMS system so I can't change the format of the input. I get the data in json or xml format, below I will show the ch...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi EmpMsgAEG ,

 

What type of effects are you wanted? Transform them to one row instead of split into two rows with key value part?

 

Can you please explain more about these and share the expected results? They will help us cleary your requirement and test to coding formulas.

 

Regards,

Xiaoxin Shen

  • EmpMsgAEG's avatar
    EmpMsgAEG
    New Member
    4 years ago

    Hi v-henryk-mstf 

     

    exactly, so I need one row displaying the key and the value, where as if I use the built in function it splits the top hierarchie into two rows and then splits it into two columns.

     

    As I mentioned in the other reply I found a solution where I create an index, then duplicate the result, add +1 to one index and then do an innerjoin to combine the information on one row. This just seems very inelegant and I am unsure if it will become to slow as soon as the solution goes live with a lot of data.