2 Replies Latest reply on Jun 9, 2017 4:30 AM by ginescapote

    Importing a new csv field with records

    ginescapote

      I have 4 tables in 4 CSV files. Each table has a key, a description, an a number. The key an the description has the same data in all four  tables. For example:

       

      Csv files

      table 1, has key: 2475, description: azafran, number: 779

      table 2, has key: 2475, description: azafran, number: 456

      table 3, has key: 2475, description: azafran, number: 230

      table 4, has key: 2475, description: azafran, number: 160

       

      What I want is create only on table which contains de 4 number fields as the key and the description are repeated

       

      The result should be a unique table like:

      unique table, would be: 2475, description: azafran, n1: 779, n2: 456, n3: 230, n4: 160

       

      Please, help, I know how to do it with SQL, but have big problems conecting to ODBC, thanks