Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Parameter NameData TypeDescriptionDefault ValueExample 
LabelString

Excerpt Include
File Writer
File Writer
nopaneltrue

ELT SortSorted Employee List
Sort Paths

Required. This field set allows you to specify the sort order and placement preference for null values in each column in the table. 

Click + to add a new row. Each column for which you want to specify the sort order requires a new row.

This field set consists of the following fields:

  • Sort Path
  • Sort Order
  • Null Value Sort Preference
Sort PathStringRequired. The name of the column based on whose values you want to sort the records.N/AFNAME
Sort OrderString

Determines the order in which the values must be sorted. 

Available options are:

  • ASC: Ascending order
  • DESC: Descending order
ASCDESC
Null Value Sort PreferenceString

Determines whether the null values must be displayed first or last.

Available options are:

  • NULLS FIRST
  • NULLS LAST 
Note

This field is ignored in Azure Synapse as it does not support sorting of null values natively.


NULLS FIRSTNULLS LAST
Get preview dataCheck box
Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect
Not selectedSelected

Troubleshooting

None.

Examples

...