•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I automate ETL of MT 940 statement in power query?
As the title says I get this MT 940 statement daily from which I have to manually enter transaction data in excel. Is there a way to automate it in power query? I have tried it but the format of this statement doesn't seem to lend itself to power query. To give more detail, the statement consists of multiple field lines which have specific transaction data separated by special characters (comma, colon, back slash, number to denote swift payment method etc).
For my purpose I only need one field line 61, data in which is also separated by special characters. To make matters worse the statement is received in multiple files for a single day's transactions.
Any ideas and leads welcome.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#rows.com
#MT 940
#ETL
#power query
#transaction data
#automate