I have the attached output from a JSON Parse but stuggling to get into in the correct format using crosstab etc.
JSON Name = Column
JSON_ValueString = Values
Any guidance will be much appreciated.
Solved! Go to Solution.
Hi @tf05
You could use a multi-row formula tool to assign an ID before crosstabbing. In this case the assumption is the triggerDateTime is the first field for each set of values: