Need in Load.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Please let me know about the term Load by and how to use it.

Regards,

Lalit Kumar

Re: Need in Load.

Digvijay_Singh — Thu, 09 Jun 2016 08:07:46 GMT

Do you mean 'Order By'? If Yes then here is the description from help -

order_by

order by is a clause used for sorting the records of a resident table before they are processed by the load statement. The resident table can be sorted by one or more fields in ascending or descending order. The sorting is made primarily by numeric value and secondarily by national collation order. This clause may only be used when the data source is a resident table.

The ordering fields specify which field the resident table is sorted by. The field can be specified by its name or by its number in the resident table (the first field is number 1).

orderbyfieldlist ::= fieldname [ sortorder ] { , fieldname [ sortorder ] }

sortorder is either asc for ascending or desc for descending. If no sortorder is specified,asc is assumed.

fieldname, path, filename and aliasname are text strings representing what the respective names imply. Any field in the source table can be used as fieldname. However, fields created through the as clause (aliasname) are out of scope and cannot be used inside the same load statement.

Re: Need in Load.

Kushal_Chawda — Thu, 09 Jun 2016 08:18:23 GMT

LOAD by ?

There is

Group by & Order by

topic Need in Load. in QlikView

Need in Load.

Re: Need in Load.

Re: Need in Load.