Forum Discussion
Adding a certain field into my Table Visualization creates duplicated rows
Hi Icey,
Sorry for not getting back to you more quickly. I took a second look at my relationships, and I'm really not quite sure what could be done differently, and I couldn't find time to replicate my model without sensitive data.
But I did find a solution, although I'm not sure if it would be considered best practice; I right-clicked "Status" in the field list, and selected "First". This correctly shows the singular status for each Market/SKU pair, which I find odd because the status is defined by the Market/SKU pair, so I'm still not quite sure why it was originally disregarding that association and just duplicating the rows (one for each unique Status).
Hi Icey,
Sorry for not getting back to you more quickly. I took a second look at my relationships, and I'm really not quite sure what could be done differently, and I couldn't find time to replicate my model without sensitive data.
But I did find a solution, although I'm not sure if it would be considered best practice; I right-clicked "Status" in the field list, and selected "First". This correctly shows the singular status for each Market/SKU pair, which I find odd because the status is defined by the Market/SKU pair, so I'm still not quite sure why it was originally disregarding that association and just duplicating the rows (one for each unique Status).