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
------------------------------
Question
Need some help understanding how to sort or index in order to concatenate fields across records
This topic has been closed for replies.
+15Davis,
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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.