Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have to split my rows into multiple rows based on delimiter ",". I need to count all the unique rows in this table. Normally if i have primary key i can do that by "count(distinct Primary key)" but i don't have any primary key in my data. In this case how to count the unique rows ?
You can always create a primary key in your Load statement, e.g.
Load
RecNo() as Key,
...
From .... ;
You can always create a primary key in your Load statement, e.g.
Load
RecNo() as Key,
...
From .... ;
Thank you Henric.
Worked for me..Thanks for your help.