My requirement was also same like this, but its not working. I have two files like this.
Name
abc
def
ghi
Name0
xyz
abc
ghi
I am expecting common values which are present on both files and difference values.
Eval / if - queries are not working due to values are misplaced in files. I was trying with below query for common values
|set intersect [|inputcsv scc.csv |stats values(Name) as sccm] [|inputcsv lan.csv | stats values(Name0) as Lan]
But its not giving any outputs tried by adding fields also, no luck. can any one help me on this.
... View more
