Forum Discussion
csv value filter
Hi All, I have ID and Name column in two different tables ID is comma separated value. Table 1 ID 1,2,3 2,4 5,2 Table 2 ID Name 1 A 2 B 3 C 4 D ...
Hi Anonymous ,
You could create a column using the following formula:
Name = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Name] ), FILTER ( Table2, SEARCH ( Table2[ID], Table1[ID], 1, 0 ) > 0 ) ), [Name], "," )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi Anonymous ,
You could create a column using the following formula:
Name =
CONCATENATEX (
CALCULATETABLE (
VALUES ( Table2[Name] ),
FILTER ( Table2, SEARCH ( Table2[ID], Table1[ID], 1, 0 ) > 0 )
),
[Name],
","
)Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin