I'm generating a new table with unique records along with a record identifier, and I'm puzzled as to why I can't combine RowNo() with either DISTINCT or GROUP BY. Autonumber() on the other hand seems to work with GROUP BY.
Any ideas why that is? The entire script included below.
LOAD * INLINE [
// This works (but missing the ID column)
LOAD DISTINCT *
// Not working (shouldn't this work?) - includes all (duplicate) rows
LOAD DISTINCT RowNo() as RowId, *
// Not working (shouldn't this work?) - RowID is zero for all records