Difference between revisions of "Manuals/calci/JOIN"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
==Description==
 
==Description==
 
*This function is joining the set of numbers.  
 
*This function is joining the set of numbers.  
*In JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened),GivenSet1 and GivenSet2 are any two set of numbers.JoinType 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.
+
*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