Forum Discussion
Combine multiple rows in one in bank statement (just for one field)
I made the necessary change. Biut you have to change the name of tab with the parameter of your last step.
Use this after you last step
Table.Group(name_tab_previuo_step, {"Date"}, {{"nop", each Text.Combine(_[#"Nature de l'opération"]," ")},{"Debito", each List.First(_[Débit])}},GroupKind.Local,(x,y)=>Number.From((x=y or y[Date]<>null)))
I made the necessary change. Biut you have to change the name of tab with the parameter of your last step.
Use this after you last step
Table.Group(name_tab_previuo_step, {"Date"}, {{"nop", each Text.Combine(_[#"Nature de l'opération"]," ")},{"Debito", each List.First(_[Débit])}},GroupKind.Local,(x,y)=>Number.From((x=y or y[Date]<>null)))
It's more than perfect! Thank you soo much! 👍
the technique used here, with specific adaptations, is illustrated in the following blog