Davis,
To make sure the data looks something like this assuming five columns of data:
2, 4, 6, Count, Address
This was a strange thing make sure sales ...
3, 7, 11, Count, Address
Really good lead move to the front of the list ....
and what you want is this with six columns
2, 4, 6, Count, Address, This was a strange thing make sure sales ...
3, 7, 11, Count, Address, Really good lead move to the front of the list ....
------------------------------
Don Larson
------------------------------
Original Message:
Sent: 11-07-2022 12:53
From: Davis Ward
Subject: Need some help understanding how to sort or index in order to concatenate fields across records
I have two tables, a source table that receives a CSV daily, and a destination table that is interacted with by users. The source table drops in multiple records with the same order number. The difference between each record is that in this other program (the source of the CSVs) is listing any notes/messages on the order as a separate line. I want to concatenate them in a text field in order of their posting. How would I go about doing that?
------------------------------
Davis Ward
------------------------------