Forum Discussion
fill blank values with values in another column
Hi murali5431 ,
Just realized that the you have made the incorrect formula is not case but Table.
= Table.ReplaceValue(#"Time to complete entry",each [Vessel_Actual_Arrival_Date__c], each if [Vessel_Actual_Arrival_Date__c] <> null then [Vessel_Actual_Arrival_Date__c] else [Vessel_Estimated_Arrival_Date__c],Replacer.Replacevalue,{"Vessel_Actual_Arrival_Date__c"})
Hi murali5431 ,
First of all sorry for not refering that you must replace the Source by your previous step name so the values would be something similar to:
= Case.ReplaceValue(#"Time to complete entry",each [Vessel_Actual_Arrival_Date__c], each if [Vessel_Actual_Arrival_Date__c] <> null then [Vessel_Actual_Arrival_Date__c] else [Vessel_Estimated_Arrival_Date__c],Replacer.Replacevalue,{"Vessel_Actual_Arrival_Date__c"})
And this is not a new custom column you need to add a new custom step and then place this code on the formula bar, this will avoid creating new columns and deleting them.
Rigth click the last step on your query and then insert step after.
MFelix .. Thanks again!
I did as suggested, but I am still getting an error. I have provided a screenshot.
Regards,
Muraldhar
What's the version you are using?
MFelix .. I am using Version: 2.83.5894.661 64-bit (July 2020)
Hi murali5431 ,
Just realized that the you have made the incorrect formula is not case but Table.
= Table.ReplaceValue(#"Time to complete entry",each [Vessel_Actual_Arrival_Date__c], each if [Vessel_Actual_Arrival_Date__c] <> null then [Vessel_Actual_Arrival_Date__c] else [Vessel_Estimated_Arrival_Date__c],Replacer.Replacevalue,{"Vessel_Actual_Arrival_Date__c"})