Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
how can i load a table data against the unique values of a particular field of the table.
i.e. load table party_m with only that data which contains unique values of field party_code
You can load all distinct party_code values first:
dist_code:
load distinct party_code from party_m;
...and then load all rows where exists party_code:
party_m:
load * from party_m where exists(party_code);
- Ralf
I got it wrong in the first place.
dist_code:
load party_code where cnt = 1;
load party_code, count(party_code) as cnt from patry_m group by party_code;
Hope this helps.