Alteryx Designer

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

Which tool do I need? Break up a column into multiple concatenated lists.

Highlighted

I have a list of about 2 million VIN numbers.  I want to concatenate those VINs into a character string in the format of "VIN";"VIN";"VIN";"VIN";"VIN" in 1500 increments.   I have the data set at the end of the workflow with a column of VINs that are already in the "VIN"; format.  How do I concatenate these in 1500 long string variable? 

Highlighted
13 - Pulsar

I would suggest something along these lines:

image.png

Add a RecordID (starting value of 0), then divide that RecordID by 1500 and round down, then Summarize, grouping by the RecordID column and concatenating the VIN numbers. This should put 1500 on each row.

 

Hope it helps!

Highlighted
Alteryx Certified Partner

If I understand your question correctly, you can use the Transform:Summarize tool. For VIN, under Action, select String > Concatenate. With this option, you can specify Start, Separator and End characters for each summarized set of concatenated values. If you do not have a field to Group By that gives you the 1500 record sets, you could potentially use the Tile tool. 

 

Summarize-Concatenate String Data.png

Highlighted
ACE Emeritus
ACE Emeritus

Hi,

 

I've created a dummy workflow with VIN as a placeholder value to show how you might accomplish this.  I built it using the Generate Rows tool to create 60,000 records as a test.

Highlighted

Hi @Claje.  It seems the workflow is cutting off the values.  I should have about 1500 vins per group and I'm getting 14 in each concatenation.  Anyway around that?

Highlighted
ACE Emeritus
ACE Emeritus

That's unusual - does that happen if you try running my attached workflow as well?

Are you seeing this in the Results screen, or in a final output?

Highlighted
Alteryx Certified Partner

I would put a Select tool after the Summarize tool and check the Data Type and Size of the field. It sounds like it isn't the correct string type or size. You could try putting a Select in front of the Summarize tool the and setting VIN to V_WString with a size > ( 1500 * # of Chars in VIN).

Labels