Forum Discussion
Solved
Filtering a table using values in a separate table and wild character
Dear community, I need your help. I have a Table_A containing 2 columns: - ID - Description I have a Table_B containing one column: - Lookup And I'd like to filter the rows in Table_A...
I think I found a solution in this article:
Hope this can be of any help to other users as well
A.
aabati
I assumed there is a relationship between the tables, you would need to first split the description column by "|“. Then create a calculated table using the below function to filtered the matched results.
Table = CALCULATETABLE(TableA,FILTER(TableA,TableA[Discription.1] in VALUES(TableB[Lookup])||TableA[Discription.2] in VALUES(TableB[Lookup])||TableA[Discription.3] in VALUES(TableB[Lookup])))
BTW you could use CONCATENATE function to join them together if needed.
Best,
Paul
Thanks Paul for the replay
I understand you solution but in my case I dont have a defined and limited number of | (pipe delimiters).
This is why I was looking for a kind of "Select like %' function.
Thanks
A.
I think I found a solution in this article:
Hope this can be of any help to other users as well
A.