Multirow formula expression
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi community,
I would like to ask how to create experession in the multi row formula tool so that it can derive the result below
Company Code Period
DK01 KSL01
DK01 KSL02
DK01 KSL03
DK01 KSL04
DK01 KSL05
DK01 KSLVT
Output
Company Code Period IDDK01 KSLVT 0
DK01 KSL01 1
DK01 KSL02 2
DK01 KSL03 3
DK01 KSL04 4
DK01 KSL05 5
Appreciate the assistance and Thank you in advance
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @SH_94,
See the attached WF.
KLSVT isn't the 0 here, please explain the logic why if it should be. It looks random to me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @SH_94, it depends on what logic you want to use to sort and ID the data. Here I've sorted descending on the first 4 characters, then ascending on the number. This gets it in the right order for this example, but might not be what you want for the full data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @FinnCharlton ,
I realise this approach had limitation as it will not able to function well if i have data below:
KSLVT
KSL01
KSL02
KSL03
KSL04
KSL05
KSL10
KSL22
Many thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SH_94 The logic for the ID field is still quite unclear. What would the expected output be for this dataset?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Below contain input and output of the data
Input
Period
KSLVT
KSL01
KSL10
KSL02
KSL03
KSL05
KSL04
KSL22
Ouput
Period ID
KSLVT 0
KSL01 1
KSL02 2
KSL03 3
KSL04 4
KSL05 5
KSL10 6
KSL22 7
Many thans again for the prompt response
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)