topic Re: How to do mapping load of two common datafield between 2 different table in QlikView https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105533#M763561 <HTML><HEAD></HEAD><BODY><P>May be try like this:</P><P>GeneralInfo:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp; *</P><P>From GeneralInfo.txt;</P><P></P><P>ABC:</P><P>Mapping Load</P><P>FUELTYPE,</P><P>XYZ</P><P>Resident GeneralInfo;</P><P></P><P>SummaryTable:</P><P>Load</P><P>A,</P><P>B,</P><P>ApplyMap('ABC',FUELTYPE,'UnKnown') as FUELTYPE,</P><P>C,</P><P>D</P><P>From SummaryTable.txt;</P></BODY></HTML> Sat, 21 Jul 2018 09:29:19 GMT BalaBhaskar_Qlik 2018-07-21T09:29:19Z How to do mapping load of two common datafield between 2 different table https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105530#M763558 <HTML><HEAD></HEAD><BODY><P>I need to map FUELTYPE of general information with FUELTYPE of Summary table because they both contain the same field.How can I do it</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105530#M763558 trishita 2020-11-25T16:16:04Z Re: How to do mapping load of two common datafield between 2 different table https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105531#M763559 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think you're looking to connect two tables, right ?</P></BODY></HTML> Thu, 19 Jul 2018 11:50:43 GMT https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105531#M763559 YoussefBelloum 2018-07-19T11:50:43Z Re: How to do mapping load of two common datafield between 2 different table https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105532#M763560 <HTML><HEAD></HEAD><BODY><P>They are already connected with a key survey id</P></BODY></HTML> Thu, 19 Jul 2018 11:59:19 GMT https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105532#M763560 trishita 2018-07-19T11:59:19Z Re: How to do mapping load of two common datafield between 2 different table https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105533#M763561 <HTML><HEAD></HEAD><BODY><P>May be try like this:</P><P>GeneralInfo:</P><P>Load</P><P>&nbsp;&nbsp;&nbsp; *</P><P>From GeneralInfo.txt;</P><P></P><P>ABC:</P><P>Mapping Load</P><P>FUELTYPE,</P><P>XYZ</P><P>Resident GeneralInfo;</P><P></P><P>SummaryTable:</P><P>Load</P><P>A,</P><P>B,</P><P>ApplyMap('ABC',FUELTYPE,'UnKnown') as FUELTYPE,</P><P>C,</P><P>D</P><P>From SummaryTable.txt;</P></BODY></HTML> Sat, 21 Jul 2018 09:29:19 GMT https://community.qlik.com/t5/QlikView/How-to-do-mapping-load-of-two-common-datafield-between-2/m-p/105533#M763561 BalaBhaskar_Qlik 2018-07-21T09:29:19Z