topic Re: LOAD - concatenation in QlikView

LOAD - concatenation

Thu, 12 Jun 2014 16:20:50 GMT

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?

Re: LOAD - concatenation

Anonymous — Thu, 12 Jun 2014 16:22:36 GMT

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

Re: LOAD - concatenation

alexandros17 — Thu, 12 Jun 2014 16:23:08 GMT

Tables will be concatenated even if fields are in different order

Re: LOAD - concatenation

Anonymous — Thu, 12 Jun 2014 16:24:00 GMT

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

If you want to avoid use noconcatenate

Re: LOAD - concatenation

Anonymous — Tue, 15 Jul 2014 18:20:41 GMT

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

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

Re: LOAD - concatenation

Tue, 15 Jul 2014 19:48:04 GMT

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