Forum Discussion

JoeBrown's avatar
JoeBrown
New Member
3 years ago

Only show items with 'no data'

I have 2 tables, one imported from local excel file, another from an imported dataset. For the example of this help. Excel Table 1 Item code 1 Product SCAR123 Scarf SHIR123 Shirt ...
Need Help
JoeBrown's avatar
JoeBrown
New Member
3 years ago

Hi - Thanks. I have read through this, but these is no mention of how to show only those items with no data. Using my example 'New Table', the filter option for 'Item Code 2' shows the 1 option of 'SCAR123'. When I unselect this, is removes all the data in the table, and just the headers. There is no option to just show the blank/empty/missing data in 'Item Code 2' (and keep the columns Item Code 1 & Product for those with the missing Item Code 2)

  • mahenkj2's avatar
    mahenkj2
    Solution Sage
    3 years ago

    Hi JoeBrown 

     

    In that case, you can merge Excel Table 1 with Imported Table in Power query, and when you expand the columns from Imported Table, select join kind as below:

     

     

    Then you get result as below:

     

    This is one of the way. You can use Merge table as main table depending on your purpose.

     

    Hope it helps.