I need to delete specific rows based on specific country through Power Query.
Hi,
I have attached excel file, in that file I have table 1 (SALES) and table 2 (COUNTRY AR).
In TABLE 3 (RESULT) , I need only those values from table 1 for Country AR which are present in Table 2 and except AR all values should appear as you can see in RESULT table. ( in Excel Table 1, yellow highlighted cells should be excluded as it is not available in table 2).
I need this solution in power query please help me.
Well, probably shorter code could do it, but the one below, based on just Inner Joins, filtering and tables combining works too:
I've not inserted sorting on Country and City steps at the end of PQ to exactly reflect presented sample output - if it is needed sort first on city then on country.
Please Login or Register to view this content.
Last edited by Kaper; 11-23-2022 at 07:04 AM.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks