topic Re: Certification Question in QlikView

Certification Question

chaitanyajami — Tue, 14 Mar 2017 05:00:25 GMT

Two table structure was given and after left join, what is the no. of outcome records (no. of rows and columns)

Table A

ID, Columnc

A,111

B,222

C,333

Table B

ID,ColumnC

A, XXX

B,YYY

C,kkk

D,aaa

E,bbb

answer to above question must be 3 rows, 2 columns as per my understanding but correct answer is below one , how is it possible ?

5 rows,3columns

Re: Certification Question

Chanty4u — Tue, 14 Mar 2017 05:14:47 GMT

AM not sure try to like below

LOAD * INLINE [

ID, ColumnC

A, XXX

B, YYY

C, kkk

D, aaa

E, bbb

];

left join(b)

LOAD * INLINE [

ID, Columnc

A, 111

B, 222

C, 333

];

Re: Certification Question

neha_shirsath — Tue, 14 Mar 2017 05:26:36 GMT

Hi Chaitanya,

Answer to above question must be 3 rows, 2 columns is correct.

Please find the attached file for details.

Thanks & Regards,

Neha

Re: Certification Question

chaitanyajami — Tue, 14 Mar 2017 05:40:30 GMT

Hi Chanty,

if tables is in reverse order yeah i agree but with the above i hope its not the output.

Re: Certification Question

chaitanyajami — Tue, 14 Mar 2017 05:41:44 GMT

Hi Neha,

Thank you, even i got 3 rows , 2 columns i guess there is a mistake

Re: Certification Question

Tue, 14 Mar 2017 05:42:01 GMT

Hi Chaithanya,

Chanty4u has given correct output..

Re: Certification Question

chaitanyajami — Tue, 14 Mar 2017 05:46:31 GMT

Hi Manoj,

Ok but may be if table A becomes B , it might work Thank you

Re: Certification Question

shraddha_g — Tue, 14 Mar 2017 05:46:57 GMT

Reason is ColumnC and Columnc are 2 different columns...

thats why it created 3 Columns after left join..

Chanty4u's reply gives justification of the answer..

5 rows and 3 columns is correct..

Re: Certification Question

shraddha_g — Tue, 14 Mar 2017 05:54:16 GMT

In that case also it will create 3 columns only

Re: Certification Question

neha_shirsath — Tue, 14 Mar 2017 05:54:44 GMT

Hi,

Even table gets reverse then with the Left join rule (The keyword LEFT will retain rows from the left table but only matching rows from the right table) the Chatys output is correct.

Only the table no of rows difference is there that's why the output must b differ.

Thanks,

Neha

Re: Certification Question

chaitanyajami — Tue, 14 Mar 2017 06:05:54 GMT

Yes, i agree