Forum Discussion

chokedoke's avatar
chokedoke
Regular Visitor
8 years ago

How to report on column with multiple values split by a comma

Hi All,   I currently have a table with multiple columns. Each row has a unique index number, and there is one column that can have a varying amount of entries seperated by a comma. The other probl...
Need Help
chokedoke's avatar
chokedoke
Regular Visitor
8 years ago

Thanks, and that would work however i have a slight extra layer of complexity in that the table that needs the split has a one to many relationship with another table

 

The other table contains item history and each change to a record is kept in its own row. I am currently linking by a field called WorkItemSK which in the table we are looking at here has a single record per WorkItemSK that links to the history table that has many rows with WorkItemSK

 

So if i try to split each record into multiple rows it break this relationship.

 

Any ideas or have i just got myself into a bad situation and i need to explore something else?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

chokedoke,

You can re-create relationship . If you have duplicated values in relationship field in both tables, create another bridge table containing unique values in relationship field, then create relationship among the three tables.

Regards,
Lydia

  • chokedoke's avatar
    chokedoke
    Regular Visitor
    8 years ago

    I have heard these bridge tables mentioned before but im not really familiar with what they are or how they would be set up

     

    Could you please point me in the direction of a good example?

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      chokedoke,

      Please help to share sample data of the two tables so that I can provide you detailed steps.

      Regards,

      Lydia