Forum Discussion

Joachim2108's avatar
Joachim2108
Helper I
5 years ago
Solved

Using wildcard characters in a SWITCH function

Hi!   I'm struggling to create a new collumn with wildcard characters, based on certain values in another collumn using the SWITCH function.   The products in the original collumn are grouped bet...
  • Joachim2108's avatar
    Joachim2108
    5 years ago

    Hi all, the solution turned out to be:

     

    IF (LEFT ( Storage[Productgroup) = LEN(1)) = "3", "Tools",

    IF (LEFT ( Storage[Productgroup], LEN(1)) = "4", "Service",

    IF (LEFT ( Storage[Productgroup], LEN(1)) = "5", "Transport"

Joachim2108's avatar
Joachim2108
Helper I
5 years ago

Hi all, the solution turned out to be:

 

IF (LEFT ( Storage[Productgroup) = LEN(1)) = "3", "Tools",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "4", "Service",

IF (LEFT ( Storage[Productgroup], LEN(1)) = "5", "Transport"