topic Re: Need help: One to Many Relationship or multiple common fields (Any help will be appreciated)... in QlikView https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430239#M160398 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I built a script for your problem using the Mapping function.</P><P></P><P>Please see the attachment.</P><P></P><P>I hope this is solved your problem.</P><P></P><P></P><P>Best Regards,</P><P></P><P>Ariel</P></BODY></HTML> Mon, 03 Jun 2013 08:15:27 GMT ariel_klien 2013-06-03T08:15:27Z Need help: One to Many Relationship or multiple common fields (Any help will be appreciated)... https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430237#M160396 <HTML><HEAD></HEAD><BODY><DIV>Hi All,</DIV><DIV> </DIV><DIV>I ahve two tables Codes and Rule Type. On filed CodeID in Codes table <SPAN style="color: black; font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">which is common to many field in other table (<SPAN style="font-size: 10pt;">CaseType,</SPAN> <SPAN style="font-size: 10pt;">RelationType,</SPAN><SPAN style="font-size: 10pt;">FilingType,</SPAN><SPAN style="font-size: 10pt;">Status). Is it possible to join the to get the desired result.I am attaching an example below. Please let mw know how can I get my desired reult.</SPAN></SPAN></DIV><DIV> </DIV><DIV><SPAN style="mso-fareast-language: EN-US; mso-bidi-language: AR-SA; color: black; font-size: 10pt; mso-ansi-language: EN-US; font-family: &amp;quot; Segoe UI&amp;quot; mso-fareast-font-family;">Regards,</SPAN></DIV><DIV><SPAN style="mso-fareast-language: EN-US; mso-bidi-language: AR-SA; color: black; font-size: 10pt; mso-ansi-language: EN-US; font-family: &amp;quot; Segoe UI&amp;quot; mso-fareast-font-family;">Vikas</SPAN></DIV><DIV><SPAN style="color: black; font-family: &amp;quot;Segoe UI&amp;quot;,&amp;quot;sans-serif&amp;quot;; font-size: 10pt; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><P></P></SPAN></DIV></BODY></HTML> Fri, 31 May 2013 21:33:45 GMT https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430237#M160396 2013-05-31T21:33:45Z Re: Need help: One to Many Relationship or multiple common fields (Any help will be appreciated)... https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430238#M160397 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">See this blog post: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap" style="font-family: Arial; background-color: #ffffff;">Don't join - use Applymap instead</A><BR /></SPAN></P></BODY></HTML> Sat, 01 Jun 2013 07:02:20 GMT https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430238#M160397 Gysbert_Wassenaar 2013-06-01T07:02:20Z Re: Need help: One to Many Relationship or multiple common fields (Any help will be appreciated)... https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430239#M160398 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I built a script for your problem using the Mapping function.</P><P></P><P>Please see the attachment.</P><P></P><P>I hope this is solved your problem.</P><P></P><P></P><P>Best Regards,</P><P></P><P>Ariel</P></BODY></HTML> Mon, 03 Jun 2013 08:15:27 GMT https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430239#M160398 ariel_klien 2013-06-03T08:15:27Z Re: Need help: One to Many Relationship or multiple common fields (Any help will be appreciated)... https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430240#M160399 <HTML><HEAD></HEAD><BODY><P>Hi Arie,</P><P></P><P>Thanks a lot..my problem is resolved.</P><P></P><P>Thanks for your help.</P><P></P><P>Regards,</P><P>vikas</P></BODY></HTML> Mon, 03 Jun 2013 21:51:08 GMT https://community.qlik.com/t5/QlikView/Need-help-One-to-Many-Relationship-or-multiple-common-fields-Any/m-p/430240#M160399 2013-06-03T21:51:08Z