Difference between revisions of "Manuals/calci/JOIN"
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">''' | + | <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
- JOIN([1,2,3],[6]) = 1 6
- 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 |