Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeep92
Partner - Creator II
Partner - Creator II

DIFFERENCE IN LOADING ?

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

];

1 Reply
prma7799
Master III
Master III

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