Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create Column and perform Transformation in Single Step

Hi everyone!

 

Is it possible to Create Column and perform Transformation in Single Step.

 

Below are the two steps I use at the moment, however was wondering if there was a more efficent way to do this in a single step.

 

 

#"Step 2" = Table.DuplicateColumn(#"Step 1", "Plan Item", "Plan"),
#"Step 3" = Table.TransformColumns(#"Step 2", {{"Plan", each Text.Start(_, 3), type text}}),

 

 

Any help or advice would be most appreciated!

 

Thanks!

Tips and Tricks
  • Jakinta's avatar
    Jakinta
    5 years ago
    = Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item], 3))

2 Replies

  • Jakinta's avatar
    Jakinta
    Solution Sage
    5 years ago
    = Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item], 3))
  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    You can add a column instead

     

    = Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item],3), type text)

     

    Pat