Number of input and output field

Number of input field	:	One
Number of output field	:	One

The SplitTransposeJSON function is used to split and transpose data produced by the JSONPathParser function.

Examples of the SplitTransposeJSON function in HGrid247-3.5.

1.

Input	[{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95},{category:fiction,author:Evelyn Waugh,title:Sword of Honour,price:12.99},{category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99},{category:fiction,author:J. R. R. Tolkien,title:The Lord of the Rings,isbn:0-395-19395-8,price:22.99}]
Result	{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95} {category:fiction,author:Evelyn Waugh,title:Sword of Honour,price:12.99} {category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99} {category:fiction,author:J. R. R. Tolkien,title:The Lord of the Rings,isbn:0-395-19395-8,price:22.99}

2.

Input	[{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95},{category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99}]
Result	{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95} {category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99}

3.

Input	{Sayings of the Century,Sword of Honour,Moby Dick,The Lord of the Rings}
Result	Sayings of the Century Sword of Honour Moby Dick The Lord of the Rings