DeDuplicate On Column colkey With DataWindow In PowerBuilder
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
// check duplicate ON column colkey datatstore ds_colcheck ds_colcheck = Create datastore ds_colcheck.DataObject = "d_checkcolumn" ds_colcheck.Retrieve() ds_colcheck.SetSort( "colkey A") ds_colcheck.Sort() //THEN you can deduplicate USING THIS filter : //THIS can avoid a LOOP FOR flagging rows TO be filtered. //We use THIS technique TO deduplicate OR TO get distinct values FROM a datastore/datawindow. ds_colcheck.SetFilter( "getrow()=1 or colkey <> colkey[-1]") ds_colcheck.Filter() |
Good Luck!
Subscribe
Login
0 Comments
Oldest