4 Replies Latest reply: Nov 12, 2012 8:48 AM by mrkachhia RSS

    Divide file in two different script

      Can I load single excel file in two script?

       

      1. i.e.

      SALE is the excel file and I want to load as below

       

      In hidden script

      Field1

      Field2

      Field3

       

      In normal script

      Field4

      Field5

      Field6

       

      But need all Field shold be available in SALE table...

        • Re: Divide file in two different script

          Hi,

           

          You can do this by splitting the table on a Key field. For example, in the Hidden script you can have:

           

          Sales:

          Load

          * inline

          [
          Value
          101
          102
          103
          ]
          ;

           

          In the normal script, you can write:

           

          Load

          * inline

          [
          Value
          106
          104
          105
          ]
          ;

           

           

           

          For a little more detail,

           

          In the hidden script, you can have Field1

           

          SalesXY:

          Load * inline

          [

          Key,Field1

          101,A

          102,B

          103,C



          ]
          ;


          In the hidden script, you can have Field2

           

           

          Upon reload, the SalesXY table will should all the fields.

          Please find attachment (password for hidden script is 123456). Is that what you are looking for ?

           

          -Khaled.

           

          -Khaled.

            • Re: Divide file in two different script

              Dear Khaled,

              Thanks for your response.

              My mistake, haven't explain query in proper way.

              Please find attached excel file.

              What I want...

               

              In hidden script

              load Invoice No and Invoice Date only

               

              In Normal script

              Load Part NO, QTY, Price (INV)

               

              Basically want to hide Inovice No and Invoice Date...!!!

               

              Final outcome should be like below.

               

              Invoice NoInvoice DatePart NOQTYPrice (INV)Inv Total
              Inv 00125/09/12Part 001207.00140.00
              Inv 00125/09/12Part 002450.92203.68
              Inv 00125/09/12Part 003763.98447.86
              Inv 00230/09/12Part 0041195.16195.16
              Inv 00230/09/12Part 0055252.141260.70
              Inv 00301/10/12Part 0061284.311011.72
              Inv 00301/10/12Part 007272.65145.30
              Inv 00301/10/12Part 0086104.01624.06
              Inv 00301/10/12Part 0093515.36537.60
              Inv 00301/10/12Part 010328.8586.55
              Inv 00301/10/12Part 0111610.29164.64
              Inv 00405/10/12Part 0126610.12667.92
              Inv 00405/10/12Part 0137512.00900.00
              Inv 00520/10/12Part 0143361.511084.53