Depivot json with different number of attributes

Robi_MeRobi_Me MemberPosts:32Maven
edited January 2021 inHelp
How does one depivot a json file that has two different categories, with some shared and some unshared attributes that leads to different attribute counts?

Does one have to split the file before de-pivoting or is there a better way of selecting the attributed for de-pivoting?

我附上了我们的过程ll as the json file.

Best Answer

  • frederic_gomer_frederic_gomer_ MemberPosts:4Contributor I
    Solution Accepted
    @Robi_Me, try this process in dev environnment, the second output and third output of the SUPER JSON to DATA show the XML parameters for depivot and the first output try to automate the depivot process (it's working for a little nested json but it's not working for big nested json)
    Robi_Me

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:950Unicorn
    Hi@Robi_Me,

    this looks like a use case for theJQ extension.

    Regards,
    Balázs
  • Robi_MeRobi_Me MemberPosts:32Maven
    @BalazsBaranythis looks very promising, the only problem is that it comes up with a security violation on the free version of Studio.
    I have set the the enhanced permissions in Start Up,, any idea what could be causing this issue.?

  • Robi_MeRobi_Me MemberPosts:32Maven
    @frederic_gomer_you went above and beyond sir! Thank you!
  • Robi_MeRobi_Me MemberPosts:32Maven
    If anyone is looking to depivot Instagram look here #instagram
Sign InorRegisterto comment.