showing duplicate rows in TableBox/Straight Table

[Anonymous]

i am loading multiple excel file using *.csv

I need all duplicate Value also straight and tablebox hides duplicate Value

I Tried Rowno() but it also hides duplicate rows

[m_woolf]

In your load script:

RowNo() as LineNo,

Then include LineNo in your table. You can shrink the column as much as possible and change font color to equal background color to make the column less obtrusive.

[#3]

table box always doeas it this way

try to use straight table wit the expression =FieldIndex('MYear',MYear)

mwolf idea seems to be still the best

[whiteline]

I think  =FieldIndex('MYear',MYear) will be the same for duplicates.

Try Count(MYear) in a straight table (MYear as a dimension).

Or even Count({1<MYear={"=Count(MYear)>1"}>}MYear)

This will show only duplicated MYear-s in a straight table.

Or use =aggr(Only({1<MYear={"=Count(MYear)>1"}>}MYear), MYear) as a list box expression.

You'll see only duplicates.

[#5]

I did the same thing by changing background color of the columb and reduced its zise 60% (not able to do much more than that)....lol

[rajeshvaswani77]

Use straight table and show the row number, you must see all the rows. Then go to presentation and hide the column.

thanks,

Rajesh Vaswani