topic Error in joining the tables in QlikView https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321420#M409438 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; am doing left join in my script but while loading am getting error like problem in prefix ,what could be the reason?</P></BODY></HTML> Tue, 06 Jun 2017 16:24:14 GMT Anonymous 2017-06-06T16:24:14Z Error in joining the tables https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321420#M409438 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; am doing left join in my script but while loading am getting error like problem in prefix ,what could be the reason?</P></BODY></HTML> Tue, 06 Jun 2017 16:24:14 GMT https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321420#M409438 Anonymous 2017-06-06T16:24:14Z Re: Error in joining the tables https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321421#M409439 <HTML><HEAD></HEAD><BODY><P>Could be the reason for different combination. If possible, will you able to provide sample code</P></BODY></HTML> Tue, 06 Jun 2017 16:37:10 GMT https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321421#M409439 Anil_Babu_Samineni 2017-06-06T16:37:10Z Re: Error in joining the tables https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321422#M409440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you encounter 'illegal combination of prefixes' make sure you are not using noconcatenate function while joining or mapping.</P><P></P><P>Or if you use crosstable with leftjoin refer here <A href="https://community.qlikview.com/thread/190027" title="https://community.qlikview.com/thread/190027">illegal join on a crosstable - how do I makeit ... | Qlik Community</A></P><P></P><P>-Siva</P></BODY></HTML> Wed, 07 Jun 2017 02:18:29 GMT https://community.qlik.com/t5/QlikView/Error-in-joining-the-tables/m-p/1321422#M409440 Siva_Sankar 2017-06-07T02:18:29Z