2 Replies Latest reply: Jun 3, 2016 7:34 AM by mahesh kumar RSS

    Join Function

    kartik somasundaram

      I have attached a file with two sheets.

       

      One is BOM (Bill of materials) 1st columns is Finished Goods and 2nd column is components.

       

      The second sheet is inventory ledger.

      It has production of Finished goods and consumption of Raw materials.

       

      i want an output as follows:

       

            

      FGRMFG QtyStd QtyRM QtyVariance
      3000250241002701301301301300
      3000250241002705601301301300
      3000250241002705701301301300
      3000250241008433301301301300

       

      Std Qty is BOM Qty X FG Qty.

      i have also attached BOM file.

       

      please check and give me a solution.

       

      I am using personal edition. Hence, please write the script and do not upload qvw file.