Alteryx Designer Discussions

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

Input single field with header info, separated by commas and linebreaks

Marie_K
5 - Atom
I have a csv files with documentation header information in the first rows. I have an idea of how to save and make this documentation useful, if I can first read each item (separated by commas and line break for the first n lines) into a single column.
In my first attempt I got an error that said the input tool requires delimiters to be a single character.
 
Essentially, the data is comma separated & line break separated
Row lengths may vary.
 
For example, I would like this:
ID:52,Status=Complete, Name=Hello,
Selection:,"Pick1 = A, B,","Pick2 = C,","Pick3 = D,"
Criteria:,"Output1 = ReportA","Output2 = "File"
Other:12
"A","B","C","D","E","F"
"1","0","0","0","3","0"
"1","1","0","0","10","0"
"1","6","0","0","4","0"
"1","6","0","0","4","0"
 
to become this:
ID:52
Status=Complete
Name=Hello
Selection:
"Pick1 = A, B,"
"Pick2 = C,"
"Pick3 = D,"
Criteria:
"Output1 = ReportA"
"Output2 = "File"
Other:12
 
Any help would be appreciated.  I checked the discussion boards, but didn't find anything related.  I'm a newbie, so maybe I'm not phrasing my search properly... 
6 REPLIES 6
Qiu
18 - Pollux

@Marie_K 

Hope this is what you need.

A sample CSV may help to further validte the flow.

Capture1A.PNG

Marie_K
5 - Atom

btw - Wow - I'm amazed at how quickly this was viewed.  What a community

 

Alteryx doesn't seem to like that the rows have different lengths. 

Instead of reading the row as a single field, it automatically put the row in separate fields.

I wonder if there's a way that I can force alteryx to read the csv file as a single field.

 

Marie_K
5 - Atom

I removed delimiters from my input tool, but it's still breaking the first row into separate fields.

Qiu
18 - Pollux

@Marie_K 
I modified the configuration of input tool, and the content can be imported.
Unless you have some other requirements?

Capture2A.PNGCapture2B.PNG

Marie_K
5 - Atom

Thanks, this works!  I had tried a line break delimiter before, but must have used it incorrectly.  

Qiu
18 - Pollux

@Marie_K 

Glad to help and thanks for the accept mark. 😁

Labels