RedditPP Mascot

RedditPP

r/excel • … • u/Often_Tilly

Linking two power query queries

Hi.

I have a fluke clamp meter, which will record values and then give me a .CSV reading of all of the values.

It will read two values at a time, I'm typically interested in current and frequency.

Unfortunately, the CSV will do current on one line and then frequency on the next, alternating throughout the file.

I got some good advice on the internet to copy the query, delete the odd lines from one and the even lines from the other and then merge the two queries. This does exactly what I need it to do.

However, the next file that I want to analyse, I have to point both queries at the same file. Is there a way to make these queries work such that I only have to change the query file once?

— 0