Forum Discussion
Solved
Create new column from existing columns
From above table i want to create a new column(yellow color) and get the data from existing columns(orange color). Priority should be as below: 1_ override_outcome 2_ final_recommendat...
Please paste the data alongwith column names where problem is
The code is working but not getting what i want. May be i misunderstood the concept. It fetches less data.
This is just a sample data. You will need to replace my Source with your Source statement.
I have prepared one sample Excel for you - https://1drv.ms/x/s!Akd5y6ruJhvhuV-NEWdTWmdahgPs?e=f9G5eE
i get data from mysql directly. What should i do?
1. Import data from Mysql into Power Query.
2. Open the Advanced Editor
Put following code after Source statement
#"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"stander_outcome", "recomanded_outcome", "override_outcome", "final_rcommendation_outcome"}), #"Added Custom" = Table.AddColumn(#"Replaced Value", "latest", each List.RemoveNulls({[override_outcome]}&{[final_rcommendation_outcome]}&{[recomanded_outcome]}&{[stander_outcome]}){0}) in #"Added Custom"showing this error