Converting a flat file into a VDT with calculations

2.23K views
0

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

Answered question