Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Queries in dupicates

Hello Team,

 I have two requirement which i need to get it done.Please anyone can you guide me 

  • The resultset1 is one query table will contains all the fields and will do inner join with another table called Table2.I need to find only duplicates of the num1(Synd) based on Numer and date(From table2 and resultset1 section)
  • The resultset1 is one query table will contains all the fields and will do inner join with another table called Table2.I need to find only non duplicates of the num1(Synd) based on Numer and date(From table2 and resultset1 section)

     Note : The field num1(Synd) is present in both resultset1 and table2 .

 

  Please advise 

Thanks in advance

 

Regards

RK

 

2 Replies
PrashantSangle

can you explain with sample data? with desired output?

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
RKULKARNI4
Contributor III
Contributor III
Author

Please refer the attachment

 

Regards

RK