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.


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


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


      Table 3:
      (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.