Joining the records

[sridhar_sigired]

Hi,

As i am new to qlikview, i have basic question about joins..

Table A
Joining field
1
2
3
4
5
6
7

Table B

Joining field

7

8

9

Output table should be Joining field 1 2 3 4 5 6

Which kind of join i can use to get this output? or any function?

[neha_shirsath]

Hi,

Try below code-

TableB:

LOAD * Inline [

Joining field

7

8

9

];

TableA:

LOAD [Joining field] as test Inline [

Joining field

1

2

3

4

5

6

7

];

NoConcatenate

TableAB:

Load test as final Resident TableA

Where not Exists([Joining field],test);

[tyagishaila]

TableB:

LOAD * Inline [

JoiningField

7

8

9

];

NoConcatenate

TableA:

LOAD * Inline [

JoiningField

1

2

3

4

5

6

7

]where Not Exists(JoiningField) ;

DROP Table TableB;

[#4]

Hi,

then try the load distinct

thanks,

[muthukumar77]

So Try like this,

T1Temp:

LOAD F1 as F1Temp;

LOAD * INLINE [

    F1

    1

2

3

3

3

4

5

6

7

];

Inner Join(T1Temp)

LOAD F1 as F1Temp;

LOAD * INLINE [

    F1

   3

3

7

8

];

Concatenate(T1Temp)

LOAD F1 as F1Temp;

LOAD * INLINE [

    F1

   3

3

7

8

] Where Not Exists(F1Temp,F1);

Final:

LOAD * INLINE [

    F1

   1

2

3

3

3

4

5

6

7

] Where not Exists(F1Temp,F1);

Concatenate(Final)

LOAD * INLINE [

    F1

    3

3

7

8

]Where not Exists(F1Temp,F1);

DROP Table T1Temp;

[neha_shirsath]

Hi,

Please find attached file.

Hope this will help you.

Thanks,

Neha