Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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