We have data with format like this : [success:true,result:[values:1; EUR; 1

We have data with format like this :
[success:true,result:[values:1; EUR; 12000];[values:2; AUS; 9000];[values:3; SGD; 9200];[values:4; GBT; 13000];[values:5; MYR; 5000]]

What is the best expression to select all the data of the nested value (values) by index?
What we want is more likely like this:
- Array 1st column : {1,2,3,4,5}
- Array 2nd column : {EUR,AUS,SGD,GBT,MYR}
- Array 3rd column : {12000,9000,9200,13000,50000}

Thanks

OriginalPostID-210980

OriginalPostID-210980

  Discussion posts and replies are publicly visible

Parents
  • index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),1,null)
    index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),2,null)
    index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),3,null)

    That will return the three individual chunks from the arrays.
Reply
  • index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),1,null)
    index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),2,null)
    index(merge({1; "EUR"; 12000},{2; "AUS"; 9000},{3; "SGD"; 9200},{4; "GBT"; 13000},{5; "MYR"; 5000}),3,null)

    That will return the three individual chunks from the arrays.
Children
No Data