Thank you very easy to follow, been struggling to get a badly formatted bank statement imported👍👍
@narayanshenoy9127
Жыл бұрын
Thank you very much. Learned a crucial step that was missing in other examples.
@yashparikh3884
3 ай бұрын
Thank you so much Your work is appreciable ❤
@ValentinaValdes643
4 ай бұрын
thank yoy you sace my friend and I from a Managerial Accounting Final Project :)
@nazarkamal8831
7 ай бұрын
Nice information 👍👍👍
@nazarkamal8831
7 ай бұрын
This is really interesting and informative thanks sir 👍
@MrR0o
3 ай бұрын
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
3 ай бұрын
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
@chinenyenwankwo1868
4 ай бұрын
Thank you sir but after loading there was no merged statement for me to right click
@ExcelKida
4 ай бұрын
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
@mzms00
Жыл бұрын
Sir hdfc bank ko bhi aise hi karna hai usmain lines multiples hoti hai
@ExcelKida
Жыл бұрын
Yes sure, once I get to grab any of HDFC Statement, I will demonstrate workaround to fix that too
@mzms00
Жыл бұрын
@@ExcelKida can i send you any dummy bank statement send me your email id
@ExcelKida
7 ай бұрын
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
@thomkheyonn4686
6 ай бұрын
My pdf file have 2000+ page how should I do?
@ExcelKida
6 ай бұрын
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.
Пікірлер: 17