Hello all,
As the title of this thread reads:
I have two data sources that merged create a single table conformed and filtered to my desired layout. Think of this as the master table that all subsequent tables will draw from based off of their own individual parameters. My goal is to automate the process of importing data and scrubbing it only once, after merged. I currently have to remove certain rows, usually only 6-20 out of potentially 1500-5000 rows which is why I haven't bothered seeking council on creating a step that does this in the midst of merging the data (if even possible). Any ways, lets say for simple math I refresh my query and it pulls in 100 lines of data and I have to delete 10 lines leaving me 90 lines of data that all my other tables will in some way or another use. If I try to run a query from that table, after its been "scrubbed", it still pulls from the data connection it has, this pulling the 100 rows of data instead of the desired 90. If I refresh the data from the merged query table, I am aware it would revert back to 100 rows of data.
Bottom line: Is there a way to have a data query connection within a separate worksheet that will pull from that table, creating its own table based on that queries separate parameters which would be individually refreshed after the scrubbing process puling only the remaining data?
Thanks in advance for anyone who takes the time to address my inquiry!
Bookmarks