Skip to main content
  • EN

I am new to JSON, I’ve read the guides on here and have tried several ways to sort this without success.

I’m using a JSON Reader to read from a file.

The table has just three columns: OBJ; TIMESTAMP; and PK1.

However, there are 114 attributes I can see in the Feature Information window which I need to bring into the table. (I am hoping ultimately that I won’t need 114 attributes!) 

As you can see I have tried the 4 transformers listed but without success. The answer might be to configure one of them correctly or link one to the next… but over to you clever folks to see if anyone can come up with the answer.

Thanks in advance for any words of wisdom. :-) 

 

Based on your screenshot, it looks like all of those attributes are stored in a list: DATA.W1_ASSET_CHAR{}. The number between the braces (starting with zero) is the element in the list, I can see 0-2 so that would be 3 elements in the list. You could use the ListExploder to turn those elements into individual features. And it looks like 12 attributes stored in that list.

Many thanks @liamfez - I didn’t realise those were lists, I thought they were something uniquely to do with json! I have used the ListExploder and that’s worked.

Reply


Community Stats

30,108
Posts
114,293
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.