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 val...

Need Help

v-yuta-msft
8 years ago
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

v-yuta-msft

Community Support

8 years ago

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

dhankash

New Member

8 years ago

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

Forum Discussion

Load extracted columns from query to new table