4 Replies Latest reply: Mar 29, 2012 7:07 AM by Celambarasan Adhimulam RSS

    tables

      I am concatenating the 2 tables into 1 table , now i want to identify the records from each tables respectively ??? how can i do that plz help ??? may be i can use flag ....... not sure ......

        • tables
          j i

          Yes, you can use a flag. Like this:

           

          load fieldA, fieldB, 'table1' as flag FROM yourtable;

          CONCATENATE

          LOAD fieldC, fieldY, 'table2' as flag FROM yourOtherTable;

          • tables

            hi manish,

             

            ok you are concatinating two tables since most of the fields are

            simillar right , yes go on know the problem is you need to identify the records of

            two tables for this use flag yes u are right just see how to do this

             

            Sales_ Header:

             

            ItemNo

            Documentno

            Quantity as SalesHeader_Qty,

            'Header' as Flag

             

            concatenate

             

             

            ItemNo

            Documentno

            Quantity as SalesLine_Qty,

            'Line' as Flag

             

            Warm Regards,

            Anant Dubey

            • tables

              I have a field as Employee No it contain data from both the tables , now i want to count the employee no depending upon the flag value ???????