Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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