How to combine two lookups for a report?

[revanthammineni]

Hi Everyone,

I'm working on combining two lookups for a certain report.

My question is:

Let's say I have a first  look up named hosts.csv with hosts a,b,c,d,e,f

and I have a second lookup decom.csv with hosts a,b,c.

I want to compare two lookups  and take off the values of second lookup in the first lookup. So, I should get just the "d,e,f"..

Please help me how to solve this.

TIA.

[richgalloway]

Here's one untested way to do it.  It assumes both lookups have the same column name "foo".

| inputlookup hosts.csv where NOT [ | inputlookup decom.csv | fields foo | format ]

[revanthammineni]

Thanks for the reply. May I know why we are using format command here. I know, that format puts the data into  a single value but I don't really understand why you suggesting here.