Alteryx Designer Discussions

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

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

CandidDataScientist
7 - Meteor

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? 

6 REPLIES 6
danrh
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!

KOBoyle
11 - Bolide

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

Claje
14 - Magnetar

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.

CandidDataScientist
7 - Meteor

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?

Claje
14 - Magnetar

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?

KOBoyle
11 - Bolide

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