Create new record

[#1]

  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,

[IAMDV]

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

www.QlikShare.com

[#3]

Thanks for the reply,

But I just want to do the total sales for the customer a + customer b.

Any idea?

[somenathroy]

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