Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try this,
tab1:
LOAD SNO,
[INVOICE NO],
[GENERATED DATE],
MONTH,
AMOUNT
FROM
[..\Mis_Test_Srini (1).xlsx]
(ooxml, embedded labels, header is 1 lines, table is Task1);
Dim: INVOICE NO & MONTH
Exp: Sum(AMOUNT)