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!
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,
Angelia