Forum Discussion
Fill Up or Down or both by Batch ID
I have a table with the values below. On the left is the current state. On the right is where I need to get to. Effectively, I need to fill the "Bank Account" value on all records where the Batch I...
NewStep=Table.Combine(Table.Group(PreviousStepName,{"Batch Index","Trans Index"},{"n",each let a=List.RemoveItems([Bank Account],{"",null}){0}? in Table.TransformColumns(_,{"Bank Account",each if _=null or _="" then a else _})},0,(x,y)=>Byte.From(x[Batch Index]<>y[Batch Index] or y[Trans Index]=1))[n])
wdx223_Daniel
Community Champion
Community ChampionNewStep=Table.Combine(Table.Group(PreviousStepName,{"Batch Index","Trans Index"},{"n",each let a=List.RemoveItems([Bank Account],{"",null}){0}? in Table.TransformColumns(_,{"Bank Account",each a})},0,(x,y)=>Byte.From(x[Batch Index]<>y[Batch Index] or y[Trans Index]=1))[n])