Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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.