Searching for data in other sheet

[Bharathi09]

Hi all,

I have a column in one sheet like EMPID

I have to pull data from that sheet

if i pull data, i need to check that data is present in EMPCODE field in other sheet...how to check that?

please help  thanks in advance

[Or]

I'm not quite clear what it is you're trying to do, but fields (columns) aren't "in sheets", bur rather, they are global to an app. Comparing two fields can be done in several ways, such as

If(EMPID = EMPCODE,Then,Else)

[Bharathi09]

Thanks for that

My doubt is trhat I have loaded two tables in qlik

I have a field in one table like EMPID

I have to pull data from that sheet

if i pull data, i need to check that data is presnet  in EMPCODE field in other table field ...After checking that data matches with the field in 2nd table I need to load it as EMPDATA field 

please help  

[deepanshuSh]

Based on the information provided, you are still not making much sense. Assuming you meant tables instead of sheet, and you are trying to compare two different fields present on the two separate tables, just use the if and else condition as mentioned above you will get your desired result, if you want to do it on the backend. 

Just load the required fields using mapping load and use the applymap to get the field into the first or second table as you desire.