Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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