6 Replies Latest reply: Aug 7, 2012 10:25 AM by Stefan Wühl RSS

    Calling a value from a preceding table

    Chirag Chhatralia

      Hi

       

      I want to calculate a value at script level and the values are taken from two different tables.  I'm trying to execute the following script however it doesn't recognise "factor".

       

      TableX:

           Load * Inline

           [Item,Factor

           Apples,0.1

           Oraange,0.12

           Mango,0.19

           Banana,0.11

           Kiwi,0.14];

       

      TableY:

           Load *, Price*Factor as FactorPriced;

           Load * Inline

           [Item,Price

           Apples,1.32

           Oraange,1.23

           Mango,1.95

           Banana,1.10

           Kiwi,1.45];

       

      Can some one point out what it is I'm doing wrong please?

       

      Many thanks in advance

      C