Forum Discussion
Show all rows
Hi Pragati11
Let me correct muself. Just checked my data again. (I simplified it for easier understanding) It is more of
Table 1:
1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 3 |
3 |
Table 2:
| 2 | $100 |
| 3 | $85 |
| 5 | $55 |
| 9 | $75 |
The 2 columns that I am trying to form a relationship with is the 2 IDs and I am expecting this output:
| 1 |
|
| 2 | $100 |
| 3 | $85 |
| 3 | $85 |
| 3 | $85 |
| 4 | |
| 5 | $55 |
The current relationship they have now is a many to many relationship for ID as no other relationship seems to work. The expected data may not make sense but there are other columns that exist as well. I just wanted to simplify it.
Many thanks in advanced.
Hi Anonymous ,
Please turn on the option of "Show items with no data".
I tried changing it but it is still the same showling repeated values for all the rows.
Hi Anonymous ,
The table visual will hide the duplicated values by default. If you want to all of them, please drag other columns into the visual. I use an index column in my sample below, .
You could vote up the idea: Show all data in table visualization, do NOT hide duplicates to get this feature fixed quickly.
I do not want the duplicated values. I just want to fix the issue of the set of values being repeated for every row when there should not be any value at all.
Like the example below. It just keeps printing the data set for RunAmp again and again. Even for empty rows adn only has S/N.
Thank you