Forum Discussion
Solved
Remove / disable duplicates in table visual
Hey,
I have a problem where I can't get any further.
This is a table visual which is filtered for ID: "123", there are differents Names and Values - (Value) do not care.
I want a IF function, that if the ID and den Name of the Component Equal there should only display one column
-> in the Case it dosent matter which column from Component A remains (KC or XF - doesnt matter)
| ID | Name | Value |
| 123 | Component A | KC |
| 123 | Component A | XF |
| 123 | Component B | LJM |
| 123 | Component C | LJK |
It should look like this:
| ID | Name | Value |
| 123 | Component A | KC |
| 123 | Component B | LJM |
| 123 | Component C | LJK |
or like this:
| ID | Name | Value |
| 123 | Component A | XF |
| 123 | Component B | LJM |
| 123 | Component C | LJK |
