Forum Discussion

CedricMi's avatar
CedricMi
New Member
3 years ago
Solved

Help needed: conditional combining fields on multiple rows into a single row

I need to transform PDF bank statements into an Excel file. Source:   Date Transaction description Value Date Debit Credit 08.12.2021 DIRECT DEBIT SEPA SERVECORP ECH/081221 ID 08.12.20...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    CedricMi , replace "gr" step by 

    gr = Table.Group(conformedtable2, "Date", {{"all", f}}, GroupKind.Local, (x, y) => Number.From(y <> null))
AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago

CedricMi , replace "gr" step by 

gr = Table.Group(conformedtable2, "Date", {{"all", f}}, GroupKind.Local, (x, y) => Number.From(y <> null))
CedricMi's avatar
CedricMi
New Member
3 years ago

Thanks AlienSx  !

 

Now I will try to adapt the code to the real imported PDF data.