community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Reading a CSV file

Hi, I am new to Alteryx and I am trying to read data from a CSV file. I cannot import this file due to information within but I am wondering which tools to use in order to correctly get the data that I need. 

 

My data reads such as:

 

UserName: XXXXX Name: XXXX, XXXX

designer

architext

admin

 

UserName: XXXXX Name: XXXX, XXXX

designer

architext

admin

 

UserName: XXXXX Name: XXXX, XXXX

designer

architext

admin

 

I am trying to concatenate the roles listed under the individuals name as well as UserName and Name but I am unsure how to read the data when it is in this format. Any ideas? 

Highlighted
Alteryx Certified Partner

When it comes to uniquely structured text files like this, I like to read in the data as-is and then manually parse it out, rather than trying to get the Input Data tool to do the parsing for me. For this approach I'll typically set the "Delimiters" options to "\0" which represents "no delimiter".

 

My swing at parsing this structure is attached.

Labels