0 Replies Latest reply: Mar 9, 2017 8:18 AM by Priya R RSS

    Looks like Cross table

    Priya R

      Hi Community,

       

      I have requirement excel and I need to use those columns in my select query to pick data from oracl database.

       

      Capture.JPG

      As per the excel - no need to bring columns if 'n/a', if yes need to use them in select and group by statement, if E then we have to use like sum(Expr1) as Expr1.

       

      My plan to use the excel and bring those columns in the variable(one is for select and second one is for group by statement) as per the requirement and that variable I will use in the select statement while pick the data from database.

      I have tried little bit still not get exactly what I want, can some one share your ideas.

       

      - Priya