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

 

 

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels