Cross Tab Json File after Parsing

[aysha6029]

Hi Friends,

I parse a Json File and Apply CrossTab Tool on it. The Resultant value order is getting distorted and i get a order of fields in alphabetical order ( i need the fields in the same order as in json file) . Please help me to solve this issue.

[jdunkerley79 · Accepted solution]

You need to add a row number to preserve the order. You can then crosstab on this and use a dynamic rename to relabel.

Can you post a sample of the JSON then can make something to demo?

Sample based on quandl posted

[aysha6029 · Accepted solution]

Thank You very much