topic Re: Table difference between T1 and T2 in QlikView

Table difference between T1 and T2

Wed, 25 Nov 2020 16:16:04 GMT

Why is there only one table called T1 in the data model after reload and why is T2 not represented in the data model?

T1:

LOAD * Inline [

F1, F2

a, 1

a, 2

b, 3

c, 4

];

T2:

LOAD DISTINCT * Inline [

F1, F2

a, 1

b, 3

c, 4

];

Could you please answer the above question. I am new to Qlikview.

The customer expected to get one table in the data model with the content as shown below. How would you alter the load script to get this result without changing the data in the two sources?

Re: Table difference between T1 and T2

oknotsen — Sun, 17 Jul 2016 09:41:41 GMT

Both tables have exactly the same columns; F1 and F2.

Tables that have exactly the same columns will be automatically concatenated.

If you do not want this to happen, there are two solutions:

- Don't give the columns the same name

- Use "Noconcatenate" before the load statement.

The second solution causes a synthetic key, so that probably also is not the result you want.

the content as shown below

I guess you had the intention to add an attachment of some sort, but it did not show up in your post, so we have no clue what your result should look like.

Re: Table difference between T1 and T2

Sun, 17 Jul 2016 13:08:49 GMT

I am new to qlikview. Please find the sample result for above T1 and T2 results. i need this code through script.

Re: Table difference between T1 and T2

oknotsen — Sun, 17 Jul 2016 13:38:41 GMT

Looks like what the script above does.

Bit strange that just a few seconds ago I found a topic made by you and the answer to that topic is code what you are using in this question...

How to load data statically and dynamically in script?

Re: Table difference between T1 and T2

MarcoWedel — Sun, 17 Jul 2016 20:56:41 GMT

maybe this helps:

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/LoadData/concatenate-tables.htm

regards

Marco