topic Re: List comparison - what is wrong with my concatenate syntax? in QlikView https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134891#M630943 <HTML><HEAD></HEAD><BODY><P>I suggest to create the resident load with the flag value and then try</P></BODY></HTML> Fri, 02 Sep 2016 03:53:04 GMT Anil_Babu_Samineni 2016-09-02T03:53:04Z List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134888#M630939 <HTML><HEAD></HEAD><BODY><P>Hi folks</P><P>I thought i understood the syntax I copied from John Witherspoon's script on how to compare 2 lists.</P><P>I then massaged it and it works - brilliantly making file comparison so much easier that going to excel to check!</P><P></P><P>BUT I cannot get the tables names right. This would be an added feature - I can live without it but I really like the elegance of knowing which Table the fields originally came from.</P><P></P><P>John Witherspoon uses an inline script to get the information - I use an excel file but I think the problem is in the concatenate syntax.</P><P></P><P>I have included an excel file to show the comparisons i made.</P><P></P><P>Thank you for your help</P><P>Jo</P></BODY></HTML> Fri, 02 Sep 2016 02:55:08 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134888#M630939 josephinetedesc 2016-09-02T02:55:08Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134889#M630941 <HTML><HEAD></HEAD><BODY><P>What is your question?</P><P></P><P>If you have problems with a script, I would suggest that you add the script and elaborate what the expected output is.</P></BODY></HTML> Fri, 02 Sep 2016 03:34:59 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134889#M630941 ToniKautto 2016-09-02T03:34:59Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134890#M630942 <HTML><HEAD></HEAD><BODY><P>the script is in the excel file???&nbsp; Sorry I must have not added it.&nbsp; Will check</P><P>Jo</P></BODY></HTML> Fri, 02 Sep 2016 03:40:11 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134890#M630942 josephinetedesc 2016-09-02T03:40:11Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134891#M630943 <HTML><HEAD></HEAD><BODY><P>I suggest to create the resident load with the flag value and then try</P></BODY></HTML> Fri, 02 Sep 2016 03:53:04 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134891#M630943 Anil_Babu_Samineni 2016-09-02T03:53:04Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134892#M630945 <HTML><HEAD></HEAD><BODY><P>Anil could you look at my script and tell me where to the resident load please?</P><P>Jo</P></BODY></HTML> Fri, 02 Sep 2016 04:27:43 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134892#M630945 josephinetedesc 2016-09-02T04:27:43Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134893#M630946 <HTML><HEAD></HEAD><BODY><P>To the LOAD at the top, add a new column creation line like this:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Table:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD 'Table1ACHS' AS TableName,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; rowCount,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; :</SPAN></P><P></P><P>To the CONCATENATE LOAD underneath the first LOAD, do the same with another table name like this:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">CONCATENATE</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD <SPAN style="font-size: 13.3333px;">'Table2SQL' AS TableName,</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px; font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; URNumber,</SPAN></P><P><SPAN style="font-size: 13.3333px; font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; :</SPAN></P><P></P><P>That should do it.</P><P></P><P>Peter</P></BODY></HTML> Fri, 02 Sep 2016 09:21:21 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134893#M630946 Peter_Cammaert 2016-09-02T09:21:21Z Re: List comparison - what is wrong with my concatenate syntax? https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134894#M630948 <HTML><HEAD></HEAD><BODY><P>Thank you very much Peter - exactly what I need - I knew I was doing something wrong!</P></BODY></HTML> Fri, 02 Sep 2016 11:53:03 GMT https://community.qlik.com/t5/QlikView/List-comparison-what-is-wrong-with-my-concatenate-syntax/m-p/1134894#M630948 josephinetedesc 2016-09-02T11:53:03Z