PadRight without Delimiter?

Hi Community!

I built over 100 fields with fixed length in Alteryx workflow, and the output is a .txt file, how do I output it to where these fields are closed together without the tab or space delimiter?

For example, Field A length is 8, Field B length is 3,

the output in the .txt should be:

12345678ABC

I may be able to use concatenate but I don't know if that the right approach, and beside, since there are a lot of fields, concatenate will become a long string.

Output

Accepted answers

Luke_C

Hi @rockeylearning

Try using \0 as the delimiter when you configure the output tool. This is the syntax to indicate no delimiter.

Edited for correct syntax

All comments

Luke_C

Hi @rockeylearning

Try using \0 as the delimiter when you configure the output tool. This is the syntax to indicate no delimiter.

Edited for correct syntax

caltang

Perhaps if you can, kindly provide some raw data and we can show you. Otherwise it may not answer your need properly.

Peachyco

According to this post, Alteryx string fields can take about 2 billion characters. It's pretty hard to even come close to that limit - concatenating 200 fields with 100 characters each only comes up to 20,000 characters. So, concatenating your string fields and then saving only that concatenated field in the text file might still be a sound solution.

Here's a sample workflow:

Alteryx screenshot.png

Here's the text file:

Alteryx screenshot.png

Peachyco

@Luke_C

If I'm not mistaken, the delimiter "\n" is for a new line, which would put each cell in its own row. That's how my CSV is coming out when I use this delimiter.