2 Replies Latest reply: Jul 29, 2011 10:05 AM by Erich Shiino RSS

    TO SHOW DUPLICATE DATA

      Hi,

      While loading below files, I want to have duplicate data also from below file.

      Let me know what code should I enter.

      Last two rows are having duplicate data.

       

      Invoice NOCustomer IDProductQtyPriceTOTAL
      M001CUST001ABC10100.001000.00
      M002CUST003DEF20200.004000.00
      M003CUST002GHI30250.007500.00
      M003CUST002DEF10200.002000.00
      M004CUST005ABC20100.002000.00
      M004CUST005ABC20100.002000.00

       

      Thansk & Regards,

      Manish

        • TO SHOW DUPLICATE DATA
          Erich Shiino

          Hi, Manish

          You need to include a field to have a difference in your rows

          On the load statement, you can include something like this:

          LOAD FIELD1, FIELD2, rowno() as  ID

           

          from / Resident  .... ETC

           

          After this, if you want your data exactly like this, you can include those fields in a straight table and hide the ID and some expression to have only the columns that you need (Straight table properties -> Presentation -> Hide column)

           

          Hope this helps,

           

          Erich