https://community.qlik.com/t5/Talend-Studio/compare-multiple-records-with-same-id-and-selece-the-right/m-p/2374413#M137014 <P>Hello,</P><P>&nbsp;</P><P>You can build a routines that take as a parameter a list and return a string.</P><P>You can have a method with switch case. Then call for this routines from a tJavaRow or a tMap </P><P><A href="https://www.w3schools.com/java/java_switch.asp" alt="https://www.w3schools.com/java/java_switch.asp" target="_blank">https://www.w3schools.com/java/java_switch.asp</A></P> Wed, 12 Aug 2020 08:26:35 GMT JohnRMK 2020-08-12T08:26:35Z https://community.qlik.com/t5/Talend-Studio/compare-multiple-records-with-same-id-and-selece-the-right/m-p/2374412#M137013 <P>Hi my requirement is some thing like this ... </P><P></P><P></P><P>if I found multiple records with an exact match of Plan + ID (plan is no and ID as well )</P><P></P><P></P><P>When the Gender Served field is populated, and the values are not an exact match, and one of the values is Unknown</P><P>Then I will choose the value other than Unknown .OR I will default to Both when the values contain both Male and Female</P><P></P><P></P><P><I>Note</I>: below are examples of the logic.</P><UL><LI>Male, Female, Unknown = Both</LI><LI>Male, Female = Both</LI><LI>Female, Unknown = Female</LI><LI>Male, Unknown = Male</LI><LI>Unknown, Unknown = Unknown</LI><LI>Male, Male = Male</LI><LI>Female, Female = Female</LI><LI>Male, Female, Male = Both</LI></UL><P>Question :- if I have 10 matching records how to compare the values of all of the records for above scenario and get an output as one record .</P><P></P><P></P> Tue, 11 Aug 2020 21:30:56 GMT https://community.qlik.com/t5/Talend-Studio/compare-multiple-records-with-same-id-and-selece-the-right/m-p/2374412#M137013 sudhee 2020-08-11T21:30:56Z https://community.qlik.com/t5/Talend-Studio/compare-multiple-records-with-same-id-and-selece-the-right/m-p/2374413#M137014 <P>Hello,</P><P>&nbsp;</P><P>You can build a routines that take as a parameter a list and return a string.</P><P>You can have a method with switch case. Then call for this routines from a tJavaRow or a tMap </P><P><A href="https://www.w3schools.com/java/java_switch.asp" alt="https://www.w3schools.com/java/java_switch.asp" target="_blank">https://www.w3schools.com/java/java_switch.asp</A></P> Wed, 12 Aug 2020 08:26:35 GMT https://community.qlik.com/t5/Talend-Studio/compare-multiple-records-with-same-id-and-selece-the-right/m-p/2374413#M137014 JohnRMK 2020-08-12T08:26:35Z