2 Replies Latest reply: May 25, 2016 7:02 PM by Sunny Talwar RSS

    Syntax for Load all columns in data editor

    Janani Reddy

      I am currently using this script in my data load editor:

       

      [portfolio]:

      LIB CONNECT TO [portfolio(e45_lenovo)];

      LOAD

      [category] as CATEGORY,

      [module] as MODULE,

      [customeraccountid] as CUSTOMERACCOUNTID,

      [customername] as CUSTOMERNAME;

       

      SQL SELECT * FROM  portfolio;

       

      Since now my tables will have increasing number of columns/ renamed columns, can i have a way to avoid mentioning the column names in my script? May be something like this:

       

      [portfolio]:

      LIB CONNECT TO [portfolio(e45_lenovo)];

      LOAD ALL

       

      SQL SELECT * FROM  portfolio;

       

      Thanks,

      Janani