It seems like the expression "CNAM_InvoiceReviewData" is the source. Is this a DB query? If yes, modify it to only return unique values. Is this querying a DB view? Modify that to only return unique values.
Hi[mention:d0f4237f25f54d53ad9e3fb00c5446c4:e9ed411860ed4f2ba0265705b8793d05] Use union() function from where you are sourcing your data in the grid. Union will remove duplicates. use it like this - union (local!data,local!data)
I see the data in the grid have different set of values in all rows associated with contract IDs.
One is the row where the data from contract is there and other seems to be the resultant of some left outer joins which you have done to the tables which might be duplicating the rows .
Union function will only work if both values in the two arrays are exactly same which in this case is not .
I am not sure about your use case but you may need to rethink on the JOIN clause which is being used here . See if INNER JOIN is something which would work and would only fetch the common rows from the tables .