Difference between revisions of "Manuals/calci/JOIN"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''FTESTANALYSIS(ar1,ar2,alpha,newtableflag)'''</div><br/>")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div style="font-size:30px">'''FTESTANALYSIS(ar1,ar2,alpha,newtableflag)'''</div><br/>
+
<div style="font-size:30px">'''JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened)'''</div><br/>
 +
*<math>GivenSet1</math> and <math>GivenSet2</math> are set of numbers.
 +
 
 +
==Description==
 +
*This function is joining the set of numbers.
 +
*In <math>JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened)</math>,<math>GivenSet1</math> and <math>GivenSet2</math> are any two set of numbers.
 +
*Join Type and Join set are any positive integer value.
 +
*Here 1st number in the 1st set is joining with the 1st number in the 2nd set.
 +
*From the second number it is making the duplicate number compared with the 1st set one or less.
 +
*Suppose it is two or less numbers it is joining with the first number only.
 +
*So it is joining all the numbers in the 1st set with the 2nd set except the 1st elements from the both the sets.
 +
 
 +
==Examples==
 +
#JOIN([1,2,3],[6]) = 1  6
 +
#JOIN([4,5,6,7],[2,4,7])
 +
{| class="wikitable"
 +
|-
 +
|4|| 2
 +
|-
 +
|5 || 4
 +
|-
 +
| 5 || 7
 +
|-
 +
| 6 || 4
 +
|-
 +
| 6 || 7
 +
|-
 +
| 7 ||4
 +
|-
 +
| 7 || 7
 +
|}
 +
3.JOIN([10,11,12,13],[5,10])
 +
{| class="wikitable"
 +
|-
 +
|10|| 5
 +
|-
 +
|11 || 10
 +
|-
 +
|12 || 10
 +
|-
 +
|13||10
 +
|}
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|v=jAfNg3ylZAI|280|center|Union}}
 +
 
 +
==See Also==
 +
 
 +
*[[Manuals/calci/JOINSET| JOINSET]]
 +
*[[Manuals/calci/INSET| INSET]]
 +
*[[Manuals/calci/ODDSET| ODDSET]]
 +
 
 +
==References==
 +
*[https://en.wikipedia.org/wiki/Join_and_meet Join]
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14:52, 14 January 2019

JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened)


  • and are set of numbers.

Description

  • This function is joining the set of numbers.
  • In , and are any two set of numbers.
  • Join Type and Join set are any positive integer value.
  • Here 1st number in the 1st set is joining with the 1st number in the 2nd set.
  • From the second number it is making the duplicate number compared with the 1st set one or less.
  • Suppose it is two or less numbers it is joining with the first number only.
  • So it is joining all the numbers in the 1st set with the 2nd set except the 1st elements from the both the sets.

Examples

  1. JOIN([1,2,3],[6]) = 1 6
  2. JOIN([4,5,6,7],[2,4,7])
4 2
5 4
5 7
6 4
6 7
7 4
7 7

3.JOIN([10,11,12,13],[5,10])

10 5
11 10
12 10
13 10

Related Videos

Union

See Also

References