ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need Parsing Help - column has multiple items to parse out

Clynch039
5 - Atom

Hi all, 

 

I'm trying to parse through this line to capture the due date, completion date and status but I can't seem to figure it out. Any suggestions or guidance would be greatly appreciated!

 

[{"hasLaunchMailSent":true,"_id":"ObjectId(\"610708feef7cd7e1dafb9c89\")","courseNumber":"E-55L43","courseName":"Test Course","dueDate":"5/26/2021","completionDate":"04/07/2021 10:04:43 PM","status":"Completed"}]

 

Desired output 

 

Due DateCompletion DateStatus
5/26/202104/07/2021Completed
3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @Clynch039 

 

One way of doing this

 

Felipe_Ribeir0_0-1670514524772.png

 

TimN
13 - Pulsar

Hi,

Something like this...

 

 

Clynch039
5 - Atom

Thank you!!

Labels
Top Solution Authors