I did not use column C - Sunny.
It was something that I was just trying with 2 columns,
I want the output to be like this :
But column A ,B and C are from different excels with no linking,hence there are multiple duplicates that are coming when I am trying to make straight table out of that.
Hope you understood my requirement.
In your load script, you can try someting like this.
LOAD B as D
FROM [Excel2.xlsx] ();
LOAD C AS D
FROM [Excel3.xlsx] (); // Duplicates don't really matter much
LOAD A AS D // ???
FROM [Excel1.xlsx] ()
WHERE Not Exists(D, A);
DROP Table TableToExclude;
[Edit] Modified example to never generate duplicates, even if Excel1 contains them too...