Table difference between T1 and T2

[#1]

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

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?

[oknotsen]

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

or

- 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.

[#3]

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

[oknotsen]

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?

[MarcoWedel]

maybe this helps:

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

regards

Marco