Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Blanks in Conditional Column

Hi,   I have blanks in my column in the query and I am trying top use it in a conditional column.   What would the test be, it is not null as there is not a null in the column only a blank cell. ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may use code below.

    if Text.Trim([Column1]) = "" then
BradD's avatar
BradD
New Member
2 years ago

'null' may not work in the wizard unless the value is missing.  "blank" cells in Excel files may have the apostrophe character -- so use **** ' **** (exclude asterisks/spaces) in the wizard