Forum Discussion
Solved
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 r...
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!
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).