topic Re: How to map a Two tables? in QlikView https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404626#M150557 <HTML><HEAD></HEAD><BODY><P>A:</P><P>LOAD</P><P> Country,</P><P>rowno() as key </P><P>from tableA;</P><P>B:</P><P>load Country as country_name ,</P><P> rowno() as key</P><P> from tableB;</P></BODY></HTML> Fri, 26 Apr 2013 12:35:16 GMT 2013-04-26T12:35:16Z How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404625#M150556 <HTML><HEAD></HEAD><BODY><P>Hi team </P><P>I Have two tables</P><P></P><P>A, B tables</P><P></P><P>A:</P><P></P><P><STRONG>Country</STRONG></P><P>Usa</P><P>India</P><P>lao</P><P></P><P>B:</P><P></P><P><STRONG>Country</STRONG></P><P>United state of america</P><P>India(alternate)</P><P>lao</P><P></P><P></P><P>Now how to map B Table with A table</P><P></P><P><STRONG>Require out put:</STRONG></P><P></P><P><STRONG>Country</STRONG></P><P>Usa</P><P>India</P><P>lao</P></BODY></HTML> Fri, 26 Apr 2013 12:27:18 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404625#M150556 2013-04-26T12:27:18Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404626#M150557 <HTML><HEAD></HEAD><BODY><P>A:</P><P>LOAD</P><P> Country,</P><P>rowno() as key </P><P>from tableA;</P><P>B:</P><P>load Country as country_name ,</P><P> rowno() as key</P><P> from tableB;</P></BODY></HTML> Fri, 26 Apr 2013 12:35:16 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404626#M150557 2013-04-26T12:35:16Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404627#M150558 <HTML><HEAD></HEAD><BODY><P>its not giving require out put</P></BODY></HTML> Fri, 26 Apr 2013 13:07:01 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404627#M150558 2013-04-26T13:07:01Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404628#M150559 <HTML><HEAD></HEAD><BODY><P>How are coming your data?</P><P>Comes from the database?</P><P>It is in line?</P><P>Or a file?</P></BODY></HTML> Fri, 26 Apr 2013 13:10:11 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404628#M150559 rphpacheco 2013-04-26T13:10:11Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404629#M150560 <HTML><HEAD></HEAD><BODY><P>From first table from mysql db</P><P>second table from excel</P></BODY></HTML> Fri, 26 Apr 2013 14:44:22 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404629#M150560 2013-04-26T14:44:22Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404630#M150561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can create a mapping table :</P><P></P><P>Map_Country:</P><P>MAPPING LOAD * INLINE [</P><P>Country_name, Country</P><P>'United state of america', 'Usa'</P><P>'India(alternate)', 'India'</P><P>'lao', 'Iao' ];</P><P></P><P>Then when you load your table B (from Excel), use this formula to load the country :</P><P>ApplyMap('Map_Country', Country) as Country</P></BODY></HTML> Fri, 26 Apr 2013 14:51:31 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404630#M150561 2013-04-26T14:51:31Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404631#M150562 <HTML><HEAD></HEAD><BODY><P>iam getting&nbsp; erro Country filed not found</P></BODY></HTML> Fri, 26 Apr 2013 15:18:32 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404631#M150562 2013-04-26T15:18:32Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404632#M150563 <HTML><HEAD></HEAD><BODY><P>You have to use the name of the field as define in your excel file in the applymap statement</P></BODY></HTML> Fri, 26 Apr 2013 16:30:13 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404632#M150563 2013-04-26T16:30:13Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404633#M150564 <HTML><HEAD></HEAD><BODY><P>try this , here i'm providing two concepts of mapping--</P><P></P><P>table1:</P><P>load * from table1;</P><P></P><P>table2:</P><P>load * from table2;</P><P></P><P><STRONG>Map1:</STRONG></P><P><STRONG>MAPPING LOAD&nbsp; Country,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CountryName</STRONG></P><P><STRONG>Resident table1;</STRONG></P><P></P><P><STRONG>Mappedtable:</STRONG></P><P><STRONG>Load Country, ApplyMap('Map1', Country) as CountryName</STRONG></P><P><STRONG>resident table2;</STRONG></P><P></P><P></P><P>**********************************************************************************</P><P>You can also mapped according to this code.</P><P></P><P>load * from table1;</P><P>load * from table2;</P><P></P><P><STRONG>CountryMapName:</STRONG></P><P><STRONG>Mapping load County, countryName</STRONG></P><P><STRONG>Resident table1;</STRONG></P><P></P><P><STRONG>Map Country USING CountryMapName;</STRONG></P><P></P><P><STRONG>Data:</STRONG></P><P><STRONG>load Country</STRONG></P><P><STRONG>resident table2;</STRONG></P></BODY></HTML> Mon, 29 Apr 2013 05:26:11 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404633#M150564 2013-04-29T05:26:11Z Re: How to map a Two tables? https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404634#M150565 <HTML><HEAD></HEAD><BODY><P>hmm</P></BODY></HTML> Mon, 29 Apr 2013 06:34:22 GMT https://community.qlik.com/t5/QlikView/How-to-map-a-Two-tables/m-p/404634#M150565 2013-04-29T06:34:22Z