Forum Discussion

Rhothgar's avatar
Rhothgar
Icon for Helper IV rankHelper IV
2 years ago

Unable to get this result when I copy code into another query! Code here is in PROPER format!!

Hi all  Finally worked out how to provide sample data. Basically, I started a new example and the code below gives me the result I want. However, when I copy code into another query, it does...
Need Help
Rhothgar's avatar
Rhothgar
Icon for Helper IV rankHelper IV
2 years ago

Guys and gals,

I've managed to get it to work using this:-

= Table.AddColumn(#"Replaced Value", "Custom", each if [#"Company name (delivery)"] = null then [#"Full name (delivery)"] else [#"Company name (delivery)"])


For some strange reason, when I was typing the code manually into the "Add Conditional Column" fields, I was not getting the correct result but when I realised there was a dropdown adjacent the then and else functions, selected "Select column" and dropdown with column names appeared, by selecting the column name it works.

Can anyone say why it did not work even when I entered code manually into Advanced Editor window please?