Forum Discussion
Solved
Matching values in one table, using wildcards, with string values in another table
I have a large table (Table 1) containing a column with application names. These application names contain version numbers, etc. I would like to simplify this list of application names into ...
Hi Havrikahn
This calculated column should work.
New Column = VAR Matches = CALCULATETABLE( GENERATE( 'Table1', FILTER( Predefined, SEARCH( [Apps], [Applications], 1, 0 ) >0) ) ) RETURN CONCATENATEX( Matches, [Apps],",")Here is a PBIX file you can download to test. This will also find and append when it discovers more than one match.
https://1drv.ms/u/s!AtDlC2rep7a-oi8WmrfnWoH031de
Hi Havrikahn
This calculated column should work.
New Column =
VAR Matches =
CALCULATETABLE(
GENERATE(
'Table1',
FILTER(
Predefined,
SEARCH(
[Apps],
[Applications],
1,
0
)
>0)
)
)
RETURN
CONCATENATEX(
Matches,
[Apps],",")Here is a PBIX file you can download to test. This will also find and append when it discovers more than one match.
https://1drv.ms/u/s!AtDlC2rep7a-oi8WmrfnWoH031de
Very nice Solution!
Is there a way to filter more fitting matches to the Search?
Like I have
Predefined:
"Apple"
"Apple TV"
And now in the Applications, I have:
"Apple TV Remote"
It shows me:
"Apple, Apple TV" as match, but I only want the "better" match.