Forum Discussion

marcofalzone's avatar
marcofalzone
Icon for Helper I rankHelper I
5 years ago
Solved

AddColumn and Transform in same PowerQuery statement

Hello everybody, anyone knows some way to merge 2 Power Query statements into one? The following queries do a double step: Step 1: creates a new column based on another existing column (field typ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Having these as two steps isn't necesarily a bad thing for performance, but you can use the 'Add column' tab to select the Extract button from your [Refer] or [OriginalColumnName] column. The code should look similar to this: 

     

    = Table.AddColumn(#"Previous step name", "Text Between Delimiters", each Text.BetweenDelimiters(Text.From([OriginalColumnName], "en-US"), "mystart", "myend"), type text)

     
     
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago

Having these as two steps isn't necesarily a bad thing for performance, but you can use the 'Add column' tab to select the Extract button from your [Refer] or [OriginalColumnName] column. The code should look similar to this: 

 

= Table.AddColumn(#"Previous step name", "Text Between Delimiters", each Text.BetweenDelimiters(Text.From([OriginalColumnName], "en-US"), "mystart", "myend"), type text)