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 ID
Appreciate the assistance and Thank you in advance
Solved! Go to Solution.
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.
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
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?
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