Forum Discussion
M code to add a column new column from SQL DB
Hi Vijay,
The M code is below
let
Source = Sql.Database("Anand092.database.windows.net", "Anand092"),
edwmrtanand_service = Source{[Schema="edwmrtanand",Item="service"]}[Data],
#"Renamed Columns" = Table.RenameColumns(edwmrt_service,{{"Clm", "Claim"}, {"Hlth", "Health"}, {"Srvc", "Service"}})
in
#"Renamed Columns"
In the table is service.
Suppose if a new column say "Column 1" gets added then how can I accomodate it in M code
If Column1 is a new addition to the table, then unless you use it in your code, it will not impact you. For example, in your code, if you add a new Column1 and when you refresh your query, it will not have any impact as you are not using Column1 anywhere.
But suppose Column1 was already existing and its name is changed to Column_1 then, in Rename Columns add this also {"Column_1", "Column1"}, then whereever you are referring to Column1 in your code, that will not be impacted.
Having said that I am not sure if it answers your questions as I feel that I am missing something. Let me know what is that.