Multirow formula expression

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

Input

Company Code Period
DK01 KSL01
DK01 KSL02
DK01 KSL03
DK01 KSL04
DK01 KSL05
DK01 KSLVT

Output

Company Code Period ID
DK01 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

Common Use Cases

Accepted answers

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

Screenshot 2023-07-28 135435.png

MultiRow ID field.yxmd

All comments

See the attached WF.

KLSVT isn't the 0 here, please explain the logic why if it should be. It looks random to me.

New Workflow1.yxmd

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

Screenshot 2023-07-28 135435.png

MultiRow ID field.yxmd

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

@SH_94 The logic for the ID field is still quite unclear. What would the expected output be for this dataset?

Hi @FinnCharlton

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703