Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Parse a String into Columns and Detail Data

Gabacho
7 - Meteor

I am looking for some assistance in parsing a string that looks like:

Column1:Data1,ratePlan:sample001,Plan:null,port:null,isPMT:null,isNDEL:null,isSample:null,isNew:null,Channel:tst,Line:true

 

into a file that looks like:

 

Column1 ratePan      Plan port  isPMT isNDEL isSample isNew Channel Line
Data1      sample001 null   null  null      null       null           null     null        TRUE

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Gabacho 
Why channel column is null?

0218-Gabacho.PNG

Labels
Top Solution Authors