Forum Discussion
Newbie challenge
Hi, As a PQ newbie I can't solve this simple transformation. The data structure is very simple and obvious for a human. However, PQ can't seem to be able to figure it out with "column from exampl...
Simple for a human isn't necessarily simple for a machine...
You can add a column like
= Table.AddColumn(PriorStepOrTableName, "Dates", each if Text.Contains([Date], "-") then null else [Date], type text)Now you can just use Fill Down on the new column.
--Nate
Simple for a human isn't necessarily simple for a machine...
You can add a column like
= Table.AddColumn(PriorStepOrTableName, "Dates", each if Text.Contains([Date], "-") then null else [Date], type text)
Now you can just use Fill Down on the new column.
--Nate
Excellent! Thank you Nate.
There is a little extra step, that is to replace "Error" by "null" before fill down.
A little less newbie now 🙂
right click on the red line above and select replace errors and then type null
