ginescapote

Importing a new csv field with records

Discussion created by ginescapote on Jun 6, 2017
Latest reply on Jun 9, 2017 by 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

Outcomes