I am trying to add some calculated variables to a table I am inputting from an external file based on a second table which is not linked to the first, using the FieldValue. The secondary table has eight rows, each of which should produce new calculated fields in the primary table. I am doing the calculation in stages to keep the code from getting unwieldy. This means creating a new table for each stage, reading
I am having two problems:
a) the first three variables calculate ok, but the rest just produce zeroes,
b) the script goes continues to load the next two stages, but then gives a "Field not found" error in relation to one of the fields (TC1) defined at a previous stage.
The script is copied below.
LOAD * INLINE [
Tariffs, Monthly Subscription, Overage Charge per MB, MB included