3 Replies Latest reply: Oct 11, 2018 10:39 AM by Sneha Mahaveer RSS

    Refering multiple columns in table script using resident load

    onkar kulkarni

      Hi all,

      I am trying to load data from xlsx file in order to represent some statistical calculations in dashboard. But I am getting an issue with resident load in script.

       

      Table1
      Load
      a, b, c
      from xyz;    // I have loaded all the basic columns

       

      Table2:
      Load
      sum(a) as P
      resident Table1;   // deriving basic calculations

       

      Table 3:
      Load
      (c + P) as M
      resident Table2;  // deriving advance calculations

       

      I am getting  error as column is c not available.

       

      Please help me correct the script. Thanks in advance.