Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    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])

Anonymous's avatar
Anonymous
Not applicable
3 years ago

wdx223_Daniel 

 

This works PERFECTLY with the exception of transactions like the following (my apologies this scenario was not included in my original post):

 

Basically, only fill the null values if there are any.

 

Thank you again for your help!!

Best,

LloydW

 

 

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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])

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Absolutely AMAZING!!  Thank you soooooo much!!!