Michael Ladd
Technical User
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.
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.