Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
in Id list box ,the value will be 1
but count(Id) is 16 if we do the inner join else 8
Hello,
It should give you error because syntax of inline load
Table A:
Load * inline [
Field
aa
b
b
];
Hope this helps you
Vikas
Syntax in your script is wrong
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??
Sir, thats Typo error, Kindly answer for above query ??
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?
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
where not exist(id); means it will check id values in previous table and take only records which are not present in previous table.