This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.
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.
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).