Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate multiple rows into one

Status
Not open for further replies.

Michael Ladd

Technical User
May 8, 2021
1
US
I have up to 5 rows per ID, each with a different value in one of the fields. So I can pass all the UNIQUE IDs and that works fine, but now I want to append all the different values to that one line. So, in a nutshell:
Inbound looks like:
ID1, value1,
ID1, Value2,
ID1, Value3,
id2, Value1,
ID2, Value2,
...

What I want is:
ID1, value 1, value 2, value 3, etc..
ID2, Value 1, Value 2, etc...


Now, there is a lot of other extraneous data in the file that I don't need. So I am kind of ignoring the other 50+ fields in the file in my examples above, because there are literally only those two fields that I am worried about.

Thoughts on getting this to work? I'm sure a few years ago I would have figured this out in an hour. But it's been too long since I have had to do this.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top