Forum Discussion

cgeraeds's avatar
cgeraeds
Advocate I
7 years ago

JSON importing - expanding list

Hello community,

 

I have a problem when importing JSON files which I have searched for extensively online but can't find the correct answer to.

 

I have imported a JSON file which in the Query Editor can be converted to a table. When I expand the records I see the following:

 

Now these clients (column Name) can have multiple actions (or actie in Dutch). Therefore when I expand the column actie-datum there are a total of 7 rows visible which is corresponding to the number of actions. 

 

 

Up until now everything is going steady but now the problems start. For every of the seven rows there should be one value for all the columns which now have lists. But when I expand these too many rows are created. The other option is to extract them with a delimiter. When I do this for example with the column actie-datum-gereed the following shows:

 

For the first four rows two values per row are inserted but this isn't correct. For example for client 574, his first action has a actie-datum-gereed on 30-03-2019 and for his second action (row 2) this date is 02-04-2019. The problem intensifies when expanding all the other columns. Now is there a solution so that the correct value displays per row and not all of them. This is a fairly simple example but there are also cases in which a client has 30 actions and therefore 30 values in 30 rows. 

 

Please let me know if anymore information might be helpful.

 

Thank you in advance.


Chris

7 Replies