topic DIFFERENCE IN LOADING ? in QlikView

DIFFERENCE IN LOADING ?

pradeep92 — Thu, 02 Nov 2017 07:44:30 GMT

Hi,

what is the difference between 2 different load mentioned below ,

LOAD 1:

Invoices:

LOAD

LEN(TRIM(InvoiceID)) AS LEN,

IF(LEN(TRIM(InvoiceID))=0,Null(),InvoiceID) AS InvoiceID,

ClientID

;

LOAD *

INLINE [

InvoiceID, ClientID

Inv001,CL0001

Inv002,CL0002

,CL0003

,CL0004

];

LOAD 2:

Invoices:

LOAD

LEN(TRIM(InvoiceID)) AS LEN,

IF(LEN(TRIM(InvoiceID))=0,Null(),InvoiceID) AS InvoiceID,

ClientID

INLINE [

InvoiceID, ClientID

Inv001,CL0001

Inv002,CL0002

,CL0003

,CL0004

];

Re: DIFFERENCE IN LOADING ?

prma7799 — Thu, 02 Nov 2017 08:04:14 GMT

as per I know

Both are preceding load examples there are not too much differences between them both are giving same output. but according to syntax first one is better