I have two lookups B1.csv and B2.csv. B1 has block member and B2 has block id and both have one same column departments. I want to compare these both with departments and get matching values of Block member and BLOCK ID. I also have index Z from which I am done search along with my two looks ups  B1: BlockMember --- Department--email B2: BlockID --Department Index and B1 has email as same values so I used "lookup B1.csv" email command and got block member in my table but now I am not sure how to get blockid from b2.  My current search index=Z  pipename=static-website* |lookup b1 email |rename member AS BlockMember (got this blockmember from above lookup b1 using email from my index) |stats count by grid BlockMember  Status current table: grid----status--Blockmember so my future table should be  grid----status--BlockID--Blockmember(which will have same department) ... View more