Forum Discussion

vcb_001's avatar
vcb_001
Frequent Visitor
2 years ago
Solved

Filling blank values based on a string in another column

Hi everyone,   I have two columns in my data table, and I need to transform null values based on a string in the previous column. The structure of the data is quite straigthforward but, the issue i...
Need Help
Show and Tell
Tips and Tricks
  • DemoFour's avatar
    DemoFour
    2 years ago

    vcb_001 

    Try these steps

      #"Added Conditional Column" = Table.AddColumn(Source, "New Collumn", each if [SecondColumn] = "Unkown" then "Sales" else [SecondColumn]),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Conditional Column",{"FirstColumn", "New Collumn"})
in
    #"Removed Other Columns"
vcb_001's avatar
vcb_001
Frequent Visitor
2 years ago

I don't want to create a new column, I need to replace values.

DemoFour's avatar
DemoFour
Icon for Continued Contributor rankContinued Contributor
2 years ago

Hi vcb_001 

As you stated that you want to replace the null based on another column, then you will need some logic to do this.

You can add the logic to bring through the column you are using into the new column with the replaced values as well, then remove that column, so you are left with the one column and the values you need. 

This is a simple transformation in PQ and will evaluete the table at source and push trhough the desired output to use in your model.