Solved: Check matching data from two different tables with... - Qlik Community

Bharathi09 · ‎2022-12-28

Hi,

I need to check if data in one field of one table is matching with data in one field in other table

Both the field names are different

Please help

Thanks

MarcoWedel · ‎2022-12-30

for " ... if code1 value exists in code2 ... " it would rather be

Exists(code2,code1)

You could use this expression not only to restrict your load statement in the where clause but also as condition in an If() function that generates your desired code field.

View solution in original post

Taoufiq_Zarra · ‎2022-12-28

@Bharathi09 can you share a sample data and the expected output

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

JordyWegman · ‎2022-12-28

Hi,

As @Taoufiq_Zarra mentioned, please send some test data.

Jordy

Climber

Work smarter, not harder

Bharathi09 · ‎2022-12-29

Sure,

Sheet1:
[cid:0107d569-14fc-4dd3-8509-f50c0942d9ee]

Sheet2:
[cid:8fc06753-71cf-4c84-b831-bc84b3e0c150]

These are the two sheets I loaded in QS
I want to get that...
If code1 in sheet1 exists in code2 in sheet2 it should give that as ouput as in new field 'code' otherwishe it should give N/A

please help

JordyWegman · ‎2022-12-29

You haven't actually added the data now. Can you try again?

Jordy

Climber

Work smarter, not harder

Bharathi09 · ‎2022-12-29

code1	DOJ	DOL	City
ERG	25-8-2017	13-8-2020	Mexico
FCG	12/7/2018	15-6-2019	Texas
ERX	21-9-2018	31-08-2021	Chicago
MLS	9/9/2021	16-7-2022	Mussorie
TKG	20-6-2016	17-9-2018	Michigan

code2	ID	Name	Location
ERG	105	Chris	USA
FCG	107	James	Venezula
ERC	209	Mike	Australia
MLT	367	Michael	Mussorie
TKG	132	Thomas	Michigan

please reply

MarcoWedel · ‎2022-12-29

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

Bharathi09 · ‎2022-12-29

Does it works?
because two fileds in two different load statements with two different names

Bharathi09 · ‎2022-12-30

Does it works?
because two fileds in two different load statements with two different names

MarcoWedel · ‎2022-12-30

Yes, it does

Check matching data from two different tables with different field names

expression