Difference between revisions of "Manuals/calci/JOIN"
Jump to navigation
Jump to search
| 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. | + | *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 | ||
| + | |} | ||
Revision as of 14:27, 25 May 2017
JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened)
- and are set of numbers.
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 |