Im having some issues with using the "Conditional Column" module, for creating groups from a column containing more than 500 different values.
Right now the code for this looks like " else if [Konto] = "20230" then "Eksterne omkostning" else if [Konto] = "20235" then "Eksterne omkostning" else if [Konto] = "20240"" etc.
But I cant figure out how to make it into a shorter and easier to manage code.
So if I want to have 10 different values in one group I could do it like this:
Column = Switch([Konto]),
"20230", "20030"; "Ekstern omkostning";
Yes, you could IF() or Switch() Function to get it, see more details by this blog:
I used another method instead. By creating a SQL statement, it seems a little easier to create the new groups.
But I still need to figure out how to pick values between two values.
So from 1...5 = one group
6....8 = another group
13..15 18..20 = a third group.
Hope it makes some sence.
Try this logic:
Create a second table in Excel or something with the translations between the numbers and the text values. Use a Merge query.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.