unpropagate

The unpropagate statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.


Parameters

No parameters.


Description

The unpropagate statement removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.

This example removes duplicate names from a mailing list. If two records have the same name, this procedure will keep the one that was originally closer to the top of the database. (If you want to keep the one that was closer to the bottom of the database, use the unpropagateup statement.)

field Name
sortup
unpropagate
select Name <> ""
removeunselected

This example first uses sortup to bring all of the duplicate records together. It then uses unpropagate to clear out the duplicate names. Finally, it uses removeunselected to actually remove the duplicate records.

Note: When combined with the fillall statement, the unpropagate statement can modify invisible records as well as visible records. See the FillAll statement for details.


See Also


History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but can now be combined with the FillAll statement to modify both visible and invisible records.