Search found 16 matches

by rolo
Sat Nov 23, 2019 8:35 am
Forum: Power Query
Topic: Get data from file with changing columns and names
Replies: 0
Views: 495

Get data from file with changing columns and names

Hello, I need a query against a file that will have changing amount of columns...and changing columns headers names! For example: My query will require this columns to work: InD - Client - USD Source File 1 columns: Date - Customer - Amount - Taxes Source File 2 columns: Sales - Name - Received - Ot...
by rolo
Thu May 18, 2017 9:59 pm
Forum: Power Query
Topic: Do not process all files again, just new files
Replies: 1
Views: 2104

Do not process all files again, just new files

Definition: I consolidate many files with PowerQuery using "From Folder" Then my queries do a lot of work to flatten my data Each week I add lot of new files to my folder My problem: When I refresh the queries is taking more and more time to process, because each week I add 20 new files a...
by rolo
Wed Mar 15, 2017 10:47 pm
Forum: Power Query
Topic: Change All Queries Source Folders at once
Replies: 2
Views: 2652

Re: Change All Queries Source Folders at once

Thanks!
by rolo
Wed Mar 15, 2017 5:59 am
Forum: Power Query
Topic: Change All Queries Source Folders at once
Replies: 2
Views: 2652

Change All Queries Source Folders at once

Hello again Matt, I have many queries, all of them from different excel files. The problem is that sometimes I have to change folders or PC, and I have to manually edit each query For example, I have this: Query 1: Source = Folder.Files("F:\MainDir\A\1") Query 2: Source = Folder.Files(&quo...
by rolo
Fri Feb 24, 2017 9:39 pm
Forum: Power Query
Topic: Consolidate multiple Access files from folder
Replies: 3
Views: 2732

Re: Consolidate multiple Access files from folder

I have read your techniques and I could solve my problem

Thanks a lot for your valuable help!
by rolo
Wed Feb 22, 2017 11:22 pm
Forum: Power Query
Topic: Consolidate multiple Access files from folder
Replies: 3
Views: 2732

Re: Consolidate multiple Access files from folder

Thanks Matt,

I will try it again after I read your techniques...
by rolo
Wed Feb 22, 2017 12:25 am
Forum: Power Query
Topic: Consolidate multiple Access files from folder
Replies: 3
Views: 2732

Consolidate multiple Access files from folder

Hi again Matt, First of all I have subscribed to receive info on your upcoming PQ training...You explain things very clear! And now my question: I have many access files (all the same). I have tried to consolidate them with PQ using "From Folder" option The problem is that after checking t...
by rolo
Wed Feb 08, 2017 12:33 am
Forum: Power Query
Topic: Convert this "hell" table with Power Query
Replies: 4
Views: 3293

Re: Convert this "hell" table with Power Query

Hi Matt, your Power Query solution worked like a charm! ;)

By the way, I have bought your ebook "Learn to Write DAX"...it is very nice and I am learning a lot

Thank you very much for your great help!
by rolo
Sun Feb 05, 2017 11:07 pm
Forum: Power Query
Topic: Convert this "hell" table with Power Query
Replies: 4
Views: 3293

Re: Convert this "hell" table with Power Query

As you can see, it is only one "hell" table, but it has lot of headers and intermediate empty rows and columns

I will check your solution and will tell you something ASAP

Thanks!
by rolo
Sat Feb 04, 2017 5:40 am
Forum: Power Query
Topic: Convert this "hell" table with Power Query
Replies: 4
Views: 3293

Convert this "hell" table with Power Query

Hello, I would apprecciate your help to convert this table using Power Query.

See image and attached excel example below

Image

Thanks!

Go to advanced search