Tap to unmute

Power Query - Extract PDF Tables by the Table's Content

  Рет қаралды 2,838

BCTI

BCTI

Күн бұрын

Пікірлер: 36
@IrfanChanna
@IrfanChanna 8 күн бұрын
Sir, Every video of yours is amazing, but this one is on another level! Fantastic and excellent work!
@bcti-bcti
@bcti-bcti 7 күн бұрын
Thank you! That's so kind of you to say. Hope the content helped.
@ronaldagee7417
@ronaldagee7417 Ай бұрын
Just when I thought I had it all figured out, you showed me an easier way. Thank you for the Power Query videos; they have saved me a significant amount of time.
@bcti-bcti
@bcti-bcti Ай бұрын
So glad to hear that the video improved your workflow. Thanks for watching.
@IvanCortinas_ES
@IvanCortinas_ES Ай бұрын
As always, clarity and complete control of the situation. Extremely pro. I love these types of examples and your way of telling them, always to the point. Thanks, Bryon!
@bcti-bcti
@bcti-bcti Ай бұрын
Wow, Ivan! Such nice compliments. I'll try to keep up the work. Cheers.
@jazzista1967
@jazzista1967 Ай бұрын
Great study case. I just had the same issue yesterday when i was building a data model that had the same error when trying to refresh my changes in PQ . You pointed me in the right direction. Thanks for posting
@bcti-bcti
@bcti-bcti Ай бұрын
Perfect timing!!! Glad it helped. Thanks for watching.
@jazzista1967
@jazzista1967 Ай бұрын
@@bcti-bcti Yes Indeed. And it was exactly a prior step that i applied ( Covert dates from text to real dates) like you showed in the video. Thanks again! Man, you content is gold
@sharmarudra
@sharmarudra Ай бұрын
Awesome Video.
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you. You support is greatly appreciated.
@tonybatty504
@tonybatty504 Ай бұрын
Lots of interesting and useful elements. Thanks
@bcti-bcti
@bcti-bcti Ай бұрын
Glad you found it useful. Thanks for watching.
@kkravch
@kkravch Ай бұрын
Great job! Clear explanation with attention to details that matter. Professor!
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you!!!!
@gitgosc7075
@gitgosc7075 18 күн бұрын
absolutely georgeous!
@bcti-bcti
@bcti-bcti 18 күн бұрын
@@gitgosc7075 Thank you!!
@chrism9037
@chrism9037 Ай бұрын
Great video, thanks for explaining this so well!
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you. As always, your support does not go unnoticed.
@robbe58
@robbe58 Ай бұрын
As always, a tutorial at the top of the bill. Magnificent work, dedication, and explanation. 💯 👍
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you so much. I'm glad I was able to meet your high expectations. 😁
@kebincui
@kebincui Ай бұрын
Brilliant as always 👍
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you!!!! That's very nice of you to say.
@sujanmdsiful
@sujanmdsiful Ай бұрын
Awesome 😂. I am proud of you brother
@bcti-bcti
@bcti-bcti Ай бұрын
Thank you! That means a lot to me.
@anpham7108
@anpham7108 Ай бұрын
The way you teach is SUPER as always, thank you. I have a question in mind, how do you deal with tables that span across pages?
@bcti-bcti
@bcti-bcti Ай бұрын
THAT is a fantastic question. I hadn't though about that. I will do some testing and let you know. Cheers.
@ahmedshalaby9343
@ahmedshalaby9343 Ай бұрын
i have a problem in an append query , I append folder contain many sheets inside the sheets there are different format like mm-dd-yy or dd-mm-yy what do you suggest ?
@bcti-bcti
@bcti-bcti Ай бұрын
My guess is that you will have to find something on each sheet that indicates the country of origin to determine the correct date format. You can't really use the dates because January 2nd (01/02/2025) could be validly read as February 1st. Can you send a sample file so I can perform a more in-depth analysis? (license@bcti.com)
@ahmedshalaby9343
@ahmedshalaby9343 Ай бұрын
@@bcti-bcti thanks for your quick reply
@celestebenitez6688
@celestebenitez6688 Ай бұрын
What if its not a table but just text and numbers. What if you are extracting something that's always on the first page (name and address) And a grand total on the last page. But the last page varies from file to file? One doc the total is on the first page. On another is on page 3, then 5 and so on. Can you do an exercise like that?
@bcti-bcti
@bcti-bcti Ай бұрын
That's a lot of specific needs. As each project is unique, I would need to see the PDF files to come up with a strategy.
@celestebenitez6688
@celestebenitez6688 Ай бұрын
@@bcti-bcti ok, no prob. Just let me know where I can send sample files.
@bcti-bcti
@bcti-bcti Ай бұрын
@@celestebenitez6688 You can send the file to training@bcti.com
@celestebenitez6688
@celestebenitez6688 Ай бұрын
@@bcti-bcti just did. Thanks.
Power Query - Dynamic Range Detection
6:00
BCTI
Рет қаралды 2 М.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
When you have a very capricious child 😂😘👍
00:16
Like Asiya
Рет қаралды 18 МЛН
Mom Hack for Cooking Solo with a Little One! 🍳👶
00:15
5-Minute Crafts HOUSE
Рет қаралды 23 МЛН
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
Microsoft Excel - Function Slicers (slice ANYTHING)
27:07
Which tables are BUSIEST on my database?
5:43
SQL and Database explained!
Рет қаралды 1,5 М.
Power Query - Rounds Differently than Excel (DANGER)
9:47
Power Query - Unlimited Formulas in 1 Step
16:03
BCTI
Рет қаралды 8 М.
Power Query - Dynamic Column Selection
10:12
BCTI
Рет қаралды 7 М.
Power Query - Faster & Easier Parameters
13:38
BCTI
Рет қаралды 45 М.
Bricks Builder: : Query Loop anything from any API!
27:56
WP Easy
Рет қаралды 1,5 М.