Unfortunately Power Query lacks functionality to list / extract its own table names. I even performed Google Searched this, but this feature is missing. But as per my understanding, you can simply go ahead & combine (or append) all the tables in one go without worrying for table name, as ultimately tables are nothing but pages. Once you combine, pages loose its relevance
Yes, but for that you need to replace every remark / narration with respective expenditure / income head & also need to merge multiple bank accounts. Not advisable in Excel, go for proper books of accounts from ERP
That means Power Query is unable to decode structure of PDF file into table. Power Query is dumb when it comes to decoding tables from PDF. You will have to use some intelligent tool to convert it to Excel
I would not recommend browsing such a massive file via the Power Query PDF option, as Excel might not be able to handle such a large PDF file. Decoding tables from PDF structures is a complex task for CPU. 10-15 pages is fine, but post that volume you should consider asking Bank for CSV or fixed width textual file for account, which Power Query can work with ease for this volume.
I don't have a dummy Bank statement as such. You will have to try on your own bank statement. By the way, I have demonstrated multiple lines handling in another video. You can check out that video, of HDFC Bank on the channel
Thank you very easy to follow, been struggling to get a badly formatted bank statement imported👍👍
Thank you very much. Learned a crucial step that was missing in other examples.
You are great sir ji this is awesome ❤❤❤
This is really interesting and informative thanks sir 👍
Nice information 👍👍👍
Extremely useful
thank yoy you sace my friend and I from a Managerial Accounting Final Project :)
Thank you so much
Your work is appreciable ❤
Thank you mate :) Very helpful. I just need to find out how to add the table source name as an extra column now and I'll be happy :)
Unfortunately Power Query lacks functionality to list / extract its own table names. I even performed Google Searched this, but this feature is missing.
But as per my understanding, you can simply go ahead & combine (or append) all the tables in one go without worrying for table name, as ultimately tables are nothing but pages. Once you combine, pages loose its relevance
Sir may i know if it possible to convert bank statement to receipt and payment account in excel
Yes, but for that you need to replace every remark / narration with respective expenditure / income head & also need to merge multiple bank accounts. Not advisable in Excel, go for proper books of accounts from ERP
Thank you sir but after loading there was no merged statement for me to right click
That means Power Query is unable to decode structure of PDF file into table. Power Query is dumb when it comes to decoding tables from PDF. You will have to use some intelligent tool to convert it to Excel
My pdf file have 2000+ page how should I do?
I would not recommend browsing such a massive file via the Power Query PDF option, as Excel might not be able to handle such a large PDF file. Decoding tables from PDF structures is a complex task for CPU. 10-15 pages is fine, but post that volume you should consider asking Bank for CSV or fixed width textual file for account, which Power Query can work with ease for this volume.
Sir hdfc bank ko bhi aise hi karna hai usmain lines multiples hoti hai
Yes sure, once I get to grab any of HDFC Statement, I will demonstrate workaround to fix that too
@@ExcelKida can i send you any dummy bank statement send me your email id
I don't have a dummy Bank statement as such. You will have to try on your own bank statement. By the way, I have demonstrated multiple lines handling in another video. You can check out that video, of HDFC Bank on the channel