Hi everyone. I'm new to PQ but I am working to I'm learning because its obvious it can make my daily life easier.
I get data sets off of our test facilities in excel. They are unique data sets, so I do not want to combine them. But they each have the same number of columns and need the same cleansing.
I have worked with PQ enough to understand how to add data to a table and refresh and also how to add a file to a folder and smash them all together.
But in this case I pull data and I want to clean it. Then, later I'll have a new workbook/worksheet with a new data extraction and I want to re-use my same query.
Are PQ cleaning operations portable from workbook to workbook?
Thanks,
Mike
I get data sets off of our test facilities in excel. They are unique data sets, so I do not want to combine them. But they each have the same number of columns and need the same cleansing.
I have worked with PQ enough to understand how to add data to a table and refresh and also how to add a file to a folder and smash them all together.
But in this case I pull data and I want to clean it. Then, later I'll have a new workbook/worksheet with a new data extraction and I want to re-use my same query.
Are PQ cleaning operations portable from workbook to workbook?
Thanks,
Mike
