Forum Discussion

Aucesar's avatar
Aucesar
Helper III
2 years ago
Solved

Conditional Column - If 4th letter is N = Notebook else Workstation/Server

Hi Community,

 

I need to create this conditional column but I can´t, tried using ???N no luck.

Some advice?

 

Conditional Column - If 4th letter is N = Notebook else Workstation/Server

Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
    if Text.ToList([column_name]){3} = "N" then "Notebook" else "Workstation/Server"

2 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago
    if Text.ToList([column_name]){3} = "N" then "Notebook" else "Workstation/Server"