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