topic Re: compare two table in edit script in QlikView

compare two table in edit script

user-azadi — Thu, 01 Jun 2017 13:25:33 GMT

hi,

i want compare table1 and table2 and show difference rows in those. common filed in tables is Field1 and result must be

1,a1

2,c1

please tell me how we can do...

--------------------------------------------------------------

Table1:

LOAD * INLINE [

Field1, Name1

1, a1

2, b1

3, c1

4, d1

5, e1

];

Table2:

LOAD * INLINE [

Field1, Name2

2, b2

4, d2

5, e2

];

--------------------------------------------------------------

Re: compare two table in edit script

Anil_Babu_Samineni — Thu, 01 Jun 2017 15:15:28 GMT

2, c1 ?? or 3, c1 ??? Can you confirm once

Re: compare two table in edit script

user-azadi — Thu, 01 Jun 2017 15:25:26 GMT

excuse me Anil,i wrote wrong . 3,C1 is correct.

result must be:

1,a1

3,c1

Re: compare two table in edit script

Peter_Cammaert — Thu, 01 Jun 2017 15:44:22 GMT

Is Field1 some sort of primary key? Then this is pretty simple to accomplish in the UI: create a straight table with all three fields, and add an expression like:

IF (Name1 = Name2, 0, 1)

In your script, outer join Table2 To Table 1 and make a copy of the joined table into a second one whereby you use the expression mentioned above to set a Flag to 0 or 1. That way you'll keep the two values if they're available but different.

Re: compare two table in edit script

user-azadi — Thu, 01 Jun 2017 18:34:49 GMT

can you make qvw file sample for more understand,thanks

Re: compare two table in edit script

aarkay29 — Thu, 01 Jun 2017 18:53:34 GMT

May be this

Table2:

LOAD * INLINE [

Field1, Name2

2, b2

4, d2

5, e2

];

Table1:

LOAD * INLINE [

Field1, Name1

1, a1

2, b1

3, c1

4, d1

5, e1

]

Where not Exists(Field1);

Drop Table

Table2;

Re: compare two table in edit script

Anil_Babu_Samineni — Fri, 02 Jun 2017 05:49:04 GMT

Here you go