Forum Discussion
Filtering out data from another csv file
Hi,
I have 2 .csv files, 1st file has a column Source_IP the other file has a column TOR_IP. What i'm trying to do is take the 1st file and filter out all of the TOR_IP
I tried to create a relationship between them but it won't let me because one of the columns must have unique values. I am really new to PowerBI and i just can't seem to figure out how to do this. It seems to me it should be rather straighforward but i'm struggling. Help!
Thanks
I figured it out, I used an outer left join and merged the queries. I was then able to use a conditional column to show if the item exsisted in the 2nd table and to write TOR if yes, and the originating country if else.
This was the post that I found the answer in.
https://community.powerbi.com/t5/Desktop/MATCH-between-2-tables/td-p/87521
Thanks guys for your help!
4 Replies
KingsleyZ- Try the EXCEPT function:
https://msdn.microsoft.com/en-us/library/mt243784.aspx
You should be able to create a new table under the Modeling table and just do EXCEPT(TableA,TableB).
Hi KingsleyZ,
Please try the solution Greg_Deckler poated, and mark it as answer if you have resolved your issue. Otherwise, please feel free to ask if you still have other issue.
Best Regards,
AngeliaI figured it out, I used an outer left join and merged the queries. I was then able to use a conditional column to show if the item exsisted in the 2nd table and to write TOR if yes, and the originating country if else.
This was the post that I found the answer in.
https://community.powerbi.com/t5/Desktop/MATCH-between-2-tables/td-p/87521
Thanks guys for your help!
Hi KingsleyZ,
Congratulations, you have resolved your issue by yourself. Please mark your solution as answer, so more people will get useful information easily.
Best Regards,
Angelia
