Joining 2 tables without synthetic key

[#1]

Hello,

I am trying to join 2 tables from 2 different databases using the CONCATENATE function. I have named the field names similarly on both tables and used the FUNCTION, Concatenate Table 2: field name1, field name2 etc

I am however getting synthetic keys in my data model. What am I doing wrong?

Kind Regards,

Kevin

[#2]

Ensure you re alias your fields as in the below example

Table1:

LOAD Field1 AS Field1Name,

     Field2 AS Field2Name,

     Field1&Field2 AS Key

FROM .......

Table2:

LOAD Field1&Field2 AS Key

FROM .......

[#3]

Hi Felim,

I actually meant that I want to combine the data in the 2 tables into one table.

[sasikanth]

hi

If you are joining/concatinating then the resulting table should be single

then as far as i know there is no chance of getting synthetic keys

synthetic keys will arrise only when 2 tables are there and more than one matching field is there btwn the 2 tables

check again  you are loading any other table

[eduardo_sommer]

Hi Kevin,

Could you please share the script with the forum? There is, probably, another issue involved with the concatenate.

Eduardo

[#6]

Check your table viewer, are you ending up with one resulting table or two?  If you end up with one resulting table then you must have redundant fields somewhere else

[#7]

Table1:

LOAD Field1,

     Field2,

     Field3

FROM.....

Concatenate(Table1)

LOAD Field1,

     Field2,

     FieldX

FROM....

If your from is a resident drop the old table.