topic Re: How I can unite tables in script? in QlikView

How I can unite tables in script?

Wed, 22 Jul 2015 14:58:16 GMT

Good Day!

I need help. I have 2 tables, that I load from SQL base (Table 1 and Table 2). I need to get in script Result Table 3. I need to add to Table 1 rows from Table 2 with values in Field A, that not include in Table 1. I prepare sample:

Table 1
Field A	Field B
1	A
2	B
3	C
4	D
5	E

Table 2
Field A	Field B
4	F
5	G
6	H
7	J
8	K

Result Table 3
Field A	Field B
1	A
2	B
3	C
4	D
5	E
6	H
7	J
8	K

Thank you.

Re: How I can unite tables in script?

qlikviewwizard — Wed, 22 Jul 2015 15:03:09 GMT

Hi Please use the below script.

This will works.

Table1:

LOAD * INLINE [

Field A,Field B

1,A

2,B

3,C

4,D

5,E

];

Concatenate (Table1)

Table2:

LOAD * INLINE [

Field A,Field B

4,F

5,G

6,H

7,J

8,K

];

Re: How I can unite tables in script?

qlikviewwizard — Wed, 22 Jul 2015 15:09:27 GMT

Hi pmaxx0108

Please select Correct Answer instead of Helpful and close the thread. Thank you.

Re: How I can unite tables in script?

MK_QSL — Wed, 22 Jul 2015 15:12:36 GMT

Table1:

LOAD * INLINE [

Field A,Field B

1,A

2,B

3,C

4,D

5,E

];

Concatenate (Table1)

Table2:

LOAD * INLINE [

Field A,Field B

4,F

5,G

6,H

7,J

8,K

] Where Not Exists([Field A]);

Re: How I can unite tables in script?

dclark0699 — Wed, 22 Jul 2015 15:13:13 GMT

I think you not only want to Concatenate, but you need a WHERE NOT EXISTS to prevent loading where the field A value is in table 1.

Table1:

LOAD * INLINE [

Field A,Field B

1,A

2,B

3,C

4,D

5,E

];

Concatenate (Table1)

Table2:

LOAD * INLINE [

Field A,Field B

4,F

5,G

6,H

7,J

8,K

]

WHERE NOT EXISTS([Field A]);

Re: How I can unite tables in script?

dclark0699 — Wed, 22 Jul 2015 15:14:26 GMT

Your solution does not eliminate the values that already exist in Field A. Check again at the final results expectation. There is only 1 4 and 1 5 in the Field A. Need to include Where Not Exists

Re: How I can unite tables in script?

Wed, 22 Jul 2015 15:15:49 GMT

I need only one value 4 and 5 from Field A:

Re: How I can unite tables in script?

qlikviewwizard — Wed, 22 Jul 2015 15:18:32 GMT

Please use the below code.

Thank you.

Table1:

LOAD * INLINE [

Field A,Field B

1,A

2,B

3,C

4,D

5,E

];

Concatenate (Table1)

Table2:

LOAD * INLINE [

Field A,Field B

4,F

5,G

6,H

7,J

8,K

] Where Not Exists([Field A]);

Re: How I can unite tables in script?

Wed, 22 Jul 2015 19:29:06 GMT

Thank you all

Re: How I can unite tables in script?

qlikviewwizard — Thu, 23 Jul 2015 01:16:29 GMT

Hi pmaxx0108

Please close the thread by selecting Correct Answer. Thank you.