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?
Solved! Go to Solution.
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.
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?
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?
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).