1 Reply Latest reply: Jan 25, 2013 4:44 AM by Mohit Sharma RSS

    Number format problem after joining

    Koushik Banerjee

      There are two different inline table:

       

      ITEMMASTER:

      LOAD * INLINE [

          ITEM_ID, ITEM_SUB_ID, ITEM_NAME

          18, 37, candy

          20, 40, abc

          21, 55, pqr

      ];

       

       

      OTEHRITEMMASTER:

      NoConcatenate

      LOAD * INLINE [

          ITEM_ID, ITEM_SUB_ID, ITEM_NAME

          0018, 88, mnp

          30, 90, tuv

          27, 92, hozmola

      ];

       

       

      Now I want join two tables and  the output will be as :

      ITEM_ID,ITEM_SUBID,ITEM_NAME

      18,37,candy

      0018,88,mnp

      20,40,abc

      21,55,pqr

      27,92,hozmola

      30,90,tuv

       

      I cannot make difference between item_code 18 and 0018 after joining. If anyone have the solution please share.....