topic Re: concatenate in QlikView https://community.qlik.com/t5/QlikView/concatenate/m-p/1274049#M864902 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Please share sample data ,it will&nbsp; useful to understand your problem.</P></BODY></HTML> Fri, 16 Dec 2016 11:08:31 GMT Anonymous 2016-12-16T11:08:31Z concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274043#M864896 <HTML><HEAD></HEAD><BODY><P>I have multiple sources with some of them the same field names like year, month,material etc. when i use concate nate ..still i get the synthetic key issues.&nbsp; its is not advisable to use alias for my script.</P><P></P><P>any other ideas?</P><P></P><P>s</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274043#M864896 raadwiptec 2020-11-25T16:16:04Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274044#M864897 <HTML><HEAD></HEAD><BODY><P>Please post a small qlikview document that demonstrates the problem.</P></BODY></HTML> Fri, 16 Dec 2016 10:40:07 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274044#M864897 Gysbert_Wassenaar 2016-12-16T10:40:07Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274045#M864898 <HTML><HEAD></HEAD><BODY><P>Can you share the Sample Data / Fields which you have .</P></BODY></HTML> Fri, 16 Dec 2016 10:45:51 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274045#M864898 Anil_Babu_Samineni 2016-12-16T10:45:51Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274046#M864899 <HTML><HEAD></HEAD><BODY><P>it would be difficult as.. the existing report lines of code is more than 3000 lines and iam trying to add a new source file which has the similiar fields ..</P><P>i tried concatenating ..but iam getting sythetic keys..</P></BODY></HTML> Fri, 16 Dec 2016 10:49:54 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274046#M864899 raadwiptec 2016-12-16T10:49:54Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274047#M864900 <HTML><HEAD></HEAD><BODY><P>Make sure you're concatenating it to the right table. Make a habit of explicitly specifying the table name you want to append the data to: CONCANATE (MyTargetTable)</P></BODY></HTML> Fri, 16 Dec 2016 10:58:26 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274047#M864900 Gysbert_Wassenaar 2016-12-16T10:58:26Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274048#M864901 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use qualify and unqualify functions for avoiding synthetic keys.</P><P></P><P>Thanks,</P></BODY></HTML> Fri, 16 Dec 2016 11:07:00 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274048#M864901 Anonymous 2016-12-16T11:07:00Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274049#M864902 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Please share sample data ,it will&nbsp; useful to understand your problem.</P></BODY></HTML> Fri, 16 Dec 2016 11:08:31 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274049#M864902 Anonymous 2016-12-16T11:08:31Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274050#M864903 <HTML><HEAD></HEAD><BODY><P>Post your script.</P><P></P><P>Regards,</P></BODY></HTML> Fri, 16 Dec 2016 11:12:01 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274050#M864903 PrashantSangle 2016-12-16T11:12:01Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274051#M864904 <HTML><HEAD></HEAD><BODY><P>If you can't post the script, please post image of table viewer (Ctrl-T)</P><P>Marty.</P></BODY></HTML> Fri, 16 Dec 2016 12:55:27 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274051#M864904 martynlloyd 2016-12-16T12:55:27Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274052#M864905 <HTML><HEAD></HEAD><BODY><P>hi gysbert,</P><P></P><P>In the script there are couple of table which are made as link table.. iam basically trying to concatenate the the new source file with the Link table.. but it is going for loops..</P></BODY></HTML> Fri, 16 Dec 2016 12:58:24 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274052#M864905 raadwiptec 2016-12-16T12:58:24Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274053#M864906 <HTML><HEAD></HEAD><BODY><P>Yeah, well. I can't mind read qlikview documents half a world away. So good luck.</P></BODY></HTML> Fri, 16 Dec 2016 13:03:55 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274053#M864906 Gysbert_Wassenaar 2016-12-16T13:03:55Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274054#M864907 <HTML><HEAD></HEAD><BODY><P>try ....</P><P>after Qualifying the tables,</P><P>by Qualifying you can avoid the synthetic keys,in your situation.</P></BODY></HTML> Fri, 16 Dec 2016 13:13:41 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274054#M864907 Anonymous 2016-12-16T13:13:41Z Re: concatenate https://community.qlik.com/t5/QlikView/concatenate/m-p/1274055#M864908 <HTML><HEAD></HEAD><BODY><P>Qualfying gives an entirely new name and there would be not any link</P></BODY></HTML> Fri, 16 Dec 2016 14:28:30 GMT https://community.qlik.com/t5/QlikView/concatenate/m-p/1274055#M864908 raadwiptec 2016-12-16T14:28:30Z