In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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