How to count a unique rows after splitting a field into multiple rows based on delimiter ',' when there is no primary key

[vish123]

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 ?

[hic · Accepted solution]

You can always create a primary key in your Load statement, e.g.

Load 
RecNo() as Key,
...
From .... ;

[vish123]

Thank you Henric.

Worked for me..Thanks for your help.