AddColumns function with criteria

[aherabit]

Hi Folks.

Trying to do the following:

- search for column headers ending with '_time'

- duplicate, or AddColumns, column and change type.

existing table 

table after change

Thank you in advance...

[wdx223_Daniel · Accepted solution]

it will be easier to process this in PowerQuery

NewStep=Table.FromRecords(Table.TransformRows(PreviousStepName,each Record.TransformFields(_,List.Transform(List.Select(Record.FieldNames(_),each Text.EndsWith(_,"_time")),(x)=>{x&"_copy",(y)=>Time.From(Record.Field(_,x))}),2)))

[wdx223_Daniel · Accepted solution]

it will be easier to process this in PowerQuery

NewStep=Table.FromRecords(Table.TransformRows(PreviousStepName,each Record.TransformFields(_,List.Transform(List.Select(Record.FieldNames(_),each Text.EndsWith(_,"_time")),(x)=>{x&"_copy",(y)=>Time.From(Record.Field(_,x))}),2)))

[aherabit · Accepted solution]

Thank you very much!