Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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