Forum Discussion
Solved
Data filter based on a value to the main data set column
Hi, Thank you for assisting in advance. I been struggling for a while on this. I have a column in the main data set which has a combination of 4 words (one, two, three, four), example below....
Hi,
you can create support table to handle it, and make relation within tha two table, but you need to add index/unix column for that, example,
| Main table column | id |
| One Two | 1 |
| Two | 2 |
| One Three Four | 3 |
| Three Four | 4 |
than you can create new table from query editor base from old table and split it, it;s oke if the create new row for this because it's not the main table,
the new table will be looks like this
| Split | ID |
| One | 1 |
| Two | 1 |
| Two | 2 |
| One | 3 |
| Three | 3 |
| Four | 3 |
| Three | 4 |
| Four | 4 |
so you just need create relation betwen this two table and make a slicer filter from second table..