Nested JSON Data Not Showing Up After Crosstab

[IsaacE]

Hello everyone!

Our current workflow takes in a JSON file and flattens it out to a table structure. Unfortunately, the workflow is not showing all data nested in the JSON file. We've been scratching our heads for a while now and decided to ask for help here. 

For example, the workflow does not show "another+1/random-scrambled-id" and "another+scrambled.com/random/name-project"  in the browse tool.  Attached is a text file with mock data because json is not supported to be attached to this post. 

Any help would be appreciated!

[Felipe_Ribeir0 · Accepted solution]

Hi @IsaacE 

Adjusting the regex you will get the projects on another column: