Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts
I have a problem with a tablebox: When I load data from an sql database into this box, entires that can be found more than once in the database are only shown once. In a graph box (Chart) the values are recognized. I only have this problem in the tablebox.
Does anyone have an explanation for this phenomenon?
Thank you for your help!
Hi!
Tablebox reduces similar data. If you have some key fields(or other fields that differ), like RECID, you can add it into table box to see all data in the table
Hi!
Tablebox reduces similar data. If you have some key fields(or other fields that differ), like RECID, you can add it into table box to see all data in the table
This is working as designed. If you want to see each distinct record, you need some unique record identifier to include in the table box.
The table box (and straight tables and pivot tables) will not show duplicate rows. So if you leave out the fields that make a record unique then the table box will not show every individual record, only the unique combinations of the fields that you added as dimensions.
Thanks Kristina. That works for me.