Forum Discussion

DavisWard's avatar
DavisWard
Qrew Trainee
2 years ago

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
------------------------------

13 Replies

Sort By
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    2 years ago
    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
    ------------------------------
    • DavisWard's avatar
      DavisWard
      Qrew Trainee
      2 years ago
      I need the notes in the third column to all be merged into a matching record in another table (merged by SONO) and entered into a text field that sorts the notes by [datetime]

      ------------------------------
      Davis Ward
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        Davis, do you have a Relationship where one Sono has Many Notes?

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------