<< Click to Display Table of Contents >> Navigation:  Scripts (Batch Interface) > Syntax > Statements > ARRANGE_DISTINCT

Lets you choose what columns are printed to the HTML/XLSX/TXT document. The names of columns selected by ARRANGE_DISTINCT must match the names you can see in the document when you open it from the workspace.

 

arrange="Column1;Column2;..."

 

arrange="Creation Date;Last Update User;Auto. Deactivation;System"

selection_file='test.sel'

create_htm_file="report.htm"

 

In this case only 4 selected columns are written to report.htm.

After the file has been written the option is cleared.

 

The command prints only unique lines. No same line is ever repeated.