Interview question3

[badamsrinivas]

A:

Inline * load[

Id

1

1

1

1

];

B:

Inline * load[

Id

1

1

1

1

];

If I use Inner join between Table A, B what is the frequency of 1 Or what is out put?

[anat]

in Id list box ,the value will be 1

but count(Id) is 16 if we do the inner join else 8

[vikasmahajan]

Hello,

It should give you error  because  syntax of inline load 

Table A:

Load * inline [

Field

aa

b

b

];

Hope this helps you

Vikas

[vikasmahajan]

Syntax in your script is wrong

[badamsrinivas]

A:

Load * Inline[

Id

1

1

1

1

];

B:

Load * Inline[

Id

1

1

1

1

];

If I use Inner join between Table A, B what is the frequency of 1 Or what is out put?

Syntax i corrected, Now tell me what is about output or Frequency of 1 if i user inner join between A and B??

[badamsrinivas]

Sir, thats Typo error, Kindly answer for above query ??

[badamsrinivas]

Hi Vikas garu,

Also Please answer for below new question..

load * inline[

id,region,sales
1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000

];

load * inline[

id,region,sales
4,south,8999
5,east,8999
5,west,7788
1,east,9000
1,east,8999
] where not exist(id);

what is the output of id?

[durgesh22]

Output table will have below records

id,region,sales

1,asia,2000
1,US,3000
2,UK,3900
3,africa,8000
3,south,23000

4,south,8999
5,east,8999

[anat]

where not exist(id); means it will check id values in previous table and take only records which are not present in previous table.

[anat]

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe....