Converting a flat file into a VDT with calculations
Dear ValQ Team,
I have a data set in the following format:
Month
Half Year
Vendor
Asset
Location
Type
Type 2
Unit #
Quantity
UOM
Unit Price
Total Spend
Total Spend Gross
1-Jun-19
HY1
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Jul-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Aug-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Sep-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Oct-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Nov-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Dec-19
HY2
103
Rig
Ops
POB credit
0
Ea
0
0
0
1-Jan-19
HY1
103
Rig
Ops
Bonus
1
Mth
33689
0
0
1-Jun-19
HY1
103
Rig
Ops
Bonus
1
Mth
33689
0
0
1-Jul-19
HY2
103
Rig
Ops
Bonus
1
Mth
33689
0
0
Is it possible to create a VDT which multiplies Quantity by Unit Price using a flat data file such as this?
The VDT will have a large number of nodes (each asset has a number of locations and Types)
Thanks
Could you please write to us at support@valq.com? We’ll get in touch with you.