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

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

vish123 — Tue, 10 May 2022 06:39:31 GMT

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 ?

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

hic — Tue, 10 May 2022 06:55:13 GMT

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

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

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

vish123 — Tue, 10 May 2022 13:53:33 GMT

Thank you Henric.

Worked for me..Thanks for your help.