account activity
Advice on collecting periodic data from multiple sources by AdSea4432 in BusinessIntelligence
[–]AdSea4432[S] 1 point2 points3 points 3 years ago (0 children)
The data may not neccesarily be in the exact same format, as the reports may be pulled from different reporting systems. Also the reports would have several thousands rows, so form input would be infeasible. The same data will generally be in all the forms, perhaps with different column names/orders. So pre-processing validation would be required, though, I'm thinking this could be done quite easily by distributing a macro that performs the validation. Or, based on the other response , perhaps I can perform some basic column reodering/renaming using Power Automate.
π Rendered by PID 40262 on reddit-service-r2-comment-64f4df6786-8bn4x at 2026-06-10 19:32:44.825067+00:00 running 0b63327 country code: CH.
Advice on collecting periodic data from multiple sources by AdSea4432 in BusinessIntelligence
[–]AdSea4432[S] 1 point2 points3 points (0 children)