SOLVED
Help with Multirow funtion
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
J_SS
5 - Atom
‎11-30-2023
04:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Table Input is the current data set, I am trying to create an extra column in the output table. If [RecordID] == 1 Then 1
Elseif IsNull([RecordID]) or [RecordID] <= [Row+1:RecordID] Then [SetID] + 1
Else [SetID] endif
Input | ||
RecordID | Column 1 | Column 2 |
1 | aa | 123 |
2 | ab | 345 |
3 | ac | 123 |
4 | ad | 234 |
5 | ae | 234 |
1 | aa | 123 |
2 | ab | 345 |
3 | ac | 123 |
4 | ad | 234 |
5 | ae | 234 |
1 | aa | 123 |
2 | ab | 345 |
3 | ac | 123 |
4 | ad | 234 |
5 | ae | 234 |
output | |||
RecordID | Column 1 | Column 2 | SetID |
1 | aa | 123 | 1 |
2 | ab | 345 | 1 |
3 | ac | 123 | 1 |
4 | ad | 234 | 1 |
5 | ae | 234 | 1 |
1 | aa | 123 | 2 |
2 | ab | 345 | 2 |
3 | ac | 123 | 2 |
4 | ad | 234 | 2 |
5 | ae | 234 | 2 |
1 | aa | 123 | 3 |
2 | ab | 345 | 3 |
3 | ac | 123 | 3 |
4 | ad | 234 | 3 |
5 | ae | 234 | 3 |
Solved! Go to Solution.
Labels:
- Labels:
- Data Challenge
1 REPLY 1
17 - Castor
‎11-30-2023
06:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
