Forum Discussion
Find the value based on Comma seperated list
Hi Anonymous
For table1 , you could split the delimitted collumn into more/other columns.
Go to edit query >> Right click the column >> Split Column (By Delimiter)
This will create a table with 3 columns. A,B,C --> A | B | C
Create another custom column to concatenate all values that are not reported to.
A | B | C --> A | B | C | A, B
Split:
Result:
In table2 you can create a look up to match the reporting to values and retreive the concatenated column.
Not sure what you need with the amount.
Cheers!
A
I believe you need to create a bridging_table to link table A to B.
It will involve the split solution proposed by Anonymous . but would be better off creating it in a referenced table and pivoting the result to link to use it as a link.
Something like this: