How to read multiple lines of txt on only one line in alteryx

[Joker_Hazard]

Hi everyone!

I am trying to input a TXT file that has 10 lines. However when I input it on alteryx, it creates 10 rows. For the purpose of my automation, I need it to be read as only one line, respecting the total number of positions:

I tried using sumarize tool to concatenate, but it adds each line next to each order. I need the lines they way they are in the txt file, just in alteryx it needs to be in one row.

Image has the example, is it possible?

Thanks!

[alexnajm]

I’m confused by the ask - if it’s 10 lines in the TXT file then Alteryx will read it as 10 rows. What do you mean then by saying one line just “the way they are in the txt file”?

if you post the txt file and the expected output we may be in a better position to help. 

[Joker_Hazard]

Sure!

How it is being inputted:

 

How it needs to be:

 

The input is a txt file that is like this:

 

[alexnajm · Accepted solution]

It's hard to advise without the TXT file, but you can use the Summarize tool with \n as the separator