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.

thank yoy you sace my friend and I from a Managerial Accounting Final Project :)

Thank you so much Your work is appreciable ❤

Nice information 👍👍👍

This is really interesting and informative thanks sir 👍

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 :)

@ExcelKida

Ай бұрын

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

Thank you sir but after loading there was no merged statement for me to right click

@ExcelKida

3 ай бұрын

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

Sir hdfc bank ko bhi aise hi karna hai usmain lines multiples hoti hai

@ExcelKida

11 ай бұрын

Yes sure, once I get to grab any of HDFC Statement, I will demonstrate workaround to fix that too

@mzms00

11 ай бұрын

@@ExcelKida can i send you any dummy bank statement send me your email id

@ExcelKida

6 ай бұрын

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

My pdf file have 2000+ page how should I do?

@ExcelKida

4 ай бұрын

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.