Add Multiple Columns in One Step - Power Query

[Shreesurya]

Hi,

How to add Three Custom Column in Powerquery with static Data in one step.

I don't want to create a new step every time I add the column.

Below is an example of a table I want to add. Please help me with this.

A	B	C
1	2	3
1	2	3
1	2	3
1	2	3

 

[shaowu459]

let
    Source = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    res=Table.SplitColumn(
                            Table.AddColumn(
                                            Source,
                                            "n",
                                            each {1,2,3}
                                           ),
                            "n",
                            each _,
                            {"A","B","C"}
                         )
in
    res

 

[shaowu459]

let
    Source = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    res=Table.TransformRows(
                            Source,
                            each _&[A=1,B=2,C=3]
                           )
in
    Table.FromRecords(res)

 

[nirs87]

Or faster.....

If you know the names of the columns you want to add and hold them in a list, you can easily add any number of extra columns. The below steps assume that you hold the column names that you want to add in a list called "myListName". Try something like this:-

#"Added Custom items from LIST" = Table.AddColumn(#"myPreviousStep", "Custom", each if Table.HasColumns(#"myPreviousStep",myListName) then #"myPreviousStep" else Table.Combine({#"myPreviousStep",Table.FromRows({},myListName)})),
    #"Expand list items" = #"Added Custom items from LIST"{0}[Custom],
    #"Replaced values in items from myListName" = Table.ReplaceValue(#"Expand list items",null,1,Replacer.ReplaceValue,myListName),

Hi! this works perfectly, is there any way to make the values of the columns added "null" instead of "1"?