Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Nested JSON Data Not Showing Up After Crosstab

IsaacE
5 - Atom

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!

 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @IsaacE 

 

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

Felipe_Ribeir0_0-1670890027384.png

 

 

 

Labels
Top Solution Authors