Forum Discussion
Load extracted columns from query to new table
I have a large table which has Complaints ID and Zip Code. Zip code has recurring values because multiple complaints are received from the same zip code. I ran a Query Editor to obtain distinct values of zip codes and the total # of complaints from each. But when I close and apply, I think this new query goes back to the original table and messes up all the charts I have already built. I need to load this query to a 'new' table so I can perform other tasks with it. How can I do this?
Thanks,
Hi dhankash,
All the operation you have done in query editor will affect your report. Because data model(metadata) level will affect report level. So a simple solution to solve this problem is to duplicate a same "new" table in query editor and do operations on the duplicated table, then create visual based off the "new" table.
Regards,
Jimmy Tao
2 Replies
v-yuta-msftCommunity Support
Hi dhankash,
All the operation you have done in query editor will affect your report. Because data model(metadata) level will affect report level. So a simple solution to solve this problem is to duplicate a same "new" table in query editor and do operations on the duplicated table, then create visual based off the "new" table.
Regards,
Jimmy Tao
Thank you. This really worked. However, I wish MS would provide an option to load new Queries to a new 'location' i.e. a new table if that is what the user wants to do. dk