Forum Discussion
AddColumns function with criteria
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...
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)))
Thank you very much!
2 Replies
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)))
Thank you very much!