topic Searching for data in other sheet in App Development

Searching for data in other sheet

Bharathi09 — Mon, 26 Dec 2022 12:59:32 GMT

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

Re: Searching for data in other sheet

Or — Mon, 26 Dec 2022 13:08:36 GMT

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)

Re: Searching for data in other sheet

Bharathi09 — Mon, 26 Dec 2022 15:37:54 GMT

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

Re: Searching for data in other sheet

deepanshuSh — Mon, 26 Dec 2022 15:46:03 GMT

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.