4 Replies Latest reply: Oct 17, 2018 9:57 AM by Anil Samineni RSS

    divide the single table into 2 tables based on Field values.

    xxxxx yyyyy

      I have table like

      Table1:

      Flight, Sector,   Pax,     Fare

      123,   djhdww,    1,       1200

      123,   bdwehj,     1,       1500

      123,   jasadhj,   N/A,      2000

      124,   sgshgs,    N/A,     5000

       

       

      output tables:

       

      Connected:

      Flight, Sector,   Pax,     Fare

      123,   djhdww,    1,       1200

      123,   bdwehj,     1,       1500



      Direct Flight:

      Flight, Sector,   Pax,     Fare

      123,   jasadhj,   N/A,      2000

      124,   sgshgs,    N/A,     5000