calculation in load script creating field

[#1]

Hi all´,

potentially easy solution, need to know how to calculate same value already in load script and by that creating a field.

Example:  (Now I need the possibility to calculate the purple header during the load script)

Field Header:         Order     |         Product      |         Customer       |     Qty. Products on Order     

Field Content:          A                     small                   John                                      2

                                A                      big                      John                                     2

[#2]

hi ivan,

load

order,

product,

customer,

count(order) as Qty.Products on order

from YOURSOURCE

group by customer,product,order;

hope it helps!

Regards,

Barathiraja

[its_anandrjs]

Hi,

You are asking for table header for this you can use the variable or Calculated labels in the chart. Please share the data if have sample of this.

Ex:-

Qty * Product //As label

Regards

Anand

[#4]

Really that easy   ? Now I feel shamed

Will try it was wondering because what I will have multiple different order and customers.

Will try ....

[its_anandrjs]

Hi,

In load script if you use you have to group by by all fields available

Ex:-

Load

Order,

Product,

Customer,

Qty,

Count(Order) as OrderCount,

Qty *  Product as QtyProducts

From Source

Group by

Order,

Product,

Customer,

Qty;

For chart headers you have do like

Regards

Anand

[#6]

Okay guys,

Example:  (Now I need the possibility to calculate the purple header during the load script)

Red part I have already in my source

TABLE XYZ:

Field Header:         Order     |         Product      |         Customer       |     Qty. Products on Order     

Field Content:          A                     small                   John                                      3

                                A                      big                      John                                     3

                                A                      small                    John                                    3

                                B                      small                    Paul                                      1

This works:

TEST:
LOAD
A,
count(A) as QTY_A
RESIDENT TABLE_XYZ
group by A;

A     3

B     1

This doesn't work:

TEST:
LOAD
A,
count(A) as QTY_A,
if(wildmatch(PRODUCT,'small'),count(A),0) as QTY_small,
if(wildmatch(PRODUCT,'big'),count(A),0) as QTY_big
RESIDENT TABLE_XYZ
group by A;

expected result  

A   3    2   1

B   1    1    0