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.
