Could we create a value and assign sum (=total) of specific column of a table, during the loading script?
[Example]
We have such source data. I needed to create a value, which is Sum(TOTAL Weight) during loading, and create value, like:
Let vTotalWeight = Sum(TOTAL Weight) Resident DeliveryNote
| PalletID | BoxID | Weight |
|---|
| 1 | A | 5 |
| 1 | B | 3 |
| 2 | C | 8 |
| 3 | D | 4 |
****************************************
Let's create on QlikView. Above is:
DeliveryNote: Load * Inline [
PalletID,BoxID,Weight
1,A,5
1,B,3
2,C,8
3,D,4
] (delimiter is ',')
Could we create a value of total sum of Weight?
[Background]
I was trying creating an EDI source data (that will be further converted by the VAN vendor). In typical ASN message based on Delivery Note, we needed to place a total weight per delivery. Headers requires such values.
I appreciate for your advises in advance.
