LOAD - concatenation

[#1]

If you have Table 1 with the columns a, b, c and Table 2 with a, c, b, when you load Table 1 and then Table 2, will Table 2 be concatenated to Table 1 even though the columns are in different order?  If not, what would the result be?

[Anonymous]

Order doesn't matter. The tables will be concatenated.

[alexandros17]

Tables will be concatenated even if fields are in different order

[Anonymous]

Yes,so far the column names are same it will concatenate

If you want to avoid use noconcatenate

[Anonymous]

Yes, it  checks field names for autoconcatenate instead load order,

To avoid concatenation,Use no concatenate with Qualify function to eliminate synthetic keys.

[#6]

Hi,

Probably after that you can't do good model . Maybe you'll have synthetic keys and the data will be mess.

In the different ways you can choose different solutions but maybe at first you have to AutoNumber function.

After that you can choose some kind of join, concatenate or non concatenate your data base.

Other simple and working solution is just to rename a field. If the information in the tables is absolutely different (I mean in table 1 where A=3 and B=5 at the same time in table 2 A=3 and B=2) , you have to choose this solution. But if you don't have a field which you can link this two tables you have to work with island tables(without link the tables).

Regards,

Venelin