Identical Rows

Vikash938 — Thu, 07 Aug 2025 06:43:49 GMT

I have a data table that contains identical rows, and I want to display every single row in a table chart, exactly as it appears in the data model. the chart only displays three rows instead of the four I expect.

Re: Identical Rows

Chanty4u — Thu, 07 Aug 2025 07:21:57 GMT

Hi try this

LOAD *,

RowNo() as UniqueRowID

FROM YourSource;

Or try same as rec () as unique

In front end table add this

=RowNo(TOTAL)

Re: Identical Rows

stevedark — Thu, 07 Aug 2025 08:31:27 GMT

Hi @Vikash938

@Chanty4u's suggestion is entirely correct, if you want to see duplicate rows, but your question suggests an issue you may be missing.

In that table the first three columns should be Dimensions, but the third should be a Measure, as it is a numeric value. The Measure can be created with drag and drop or be typed in, and it simply needs to be sum(SalesAmount).

If you do this you will still get three rows, but you will have the correct total of 2,400 for that row. If you want to see that this was two laptops and not just one, you can use @Chanty4u's solution, or if you want to see it is two rows you can add a counter to the table in the load:

LOAD
1 as LineCount,
OrderID,
Product,
Region,
SalesAmount
FROM YourSource;

You can then add another measure of sum(LineCount) to show that there were two laptops sold.

The advantage of using measures (apart from the big one that duplicates can get removed) is that you also get totals for those columns.

Hope that helps.

Steve

topic Re: Identical Rows in App Development

Identical Rows

Re: Identical Rows

Re: Identical Rows