not able to join 3 ODBC query in one table

[#1]

Hi ,

I have 3 ODBC from different database. the first two join very well but the third not.

it create a double lists , where the fields in capital letter is for third odbc connection.

I give the same name to all field and with same capital letter.

Please what can be the issue?

Thanks

I

[sunny_talwar]

Rename the field names for one of the two. May be like thi:

LOAD AdministrativeEntity as ADMINISTRATIVEENTITY

          ....

or

LOAD ADMINISTRATIVEENTITY as AdministrativeEntity

          ....

HTH

Best,

Sunny

[hic]

Some ODBC drivers cannot handle field names in lower case, but always return UPPER case field names.

The solution is to use a preceding load, because then you can define your field names any way you want.

Example:

Load

     FIELD1 as Field1,

     FIELD2 as Field2;

SQL SELECT FIELD1, FIELD2 FROM TABLE;

HIC

[#4]

hi Thanks for your suggestion,

is this the structure that I should have?

A need to create one table with the 4 ODBC connection, and add some calculated field.

Please how I should load them as one table and add this field? thanks

[hic]

No, this is not a good data model. You probably want to concatenate all tables with similar content type. Like

Load ... ; SQL SELECT ... FROM <TableInSource1>;

Concatenate

Load ... ; SQL SELECT ... FROM <TableInSource2>;

Concatenate

Load ... ; SQL SELECT ... FROM <TableInSource3>;

HIC

[#6]

Hi

thanks, it work for 3 first ODBC but with this last one it now work.

It seems to be missed a variable when i go to load script..