Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hall all,
Please take a look at the attached excel and let me know how create a new record from the same table.
I already have the "a" and "b" in my table and I want to create "a*b " .
Thanks,
Hi Nima,
Have you tried something like this...
temp:
LOAD customer,
sales2
FROM
(biff, embedded labels, table is [Sheet1$]);
concatenate(temp)
LOAD customer,
sales1
FROM
(biff, embedded labels, table is [Sheet1$]);
NoConcatenate(temp)
Final_Table:
LOAD *,
Sales1 + Sales2 AS TotalSales
Resident temp;
Drop Table temp;
Cheers,
DV
Thanks for the reply,
But I just want to do the total sales for the customer a + customer b.
Any idea?
You may try below code snipet:
A:
LOAD *,1 as iq;
LOAD * Inline
[customer, sales
a, 100
b, 300];
Concatenate(A)
LOAD Concat(DISTINCT customer,',') as customer, sum(sales) as sales Resident A Group By iq;
DROP Field iq;
Regards,
Som