topic Combine data from two sources in QlikView https://community.qlik.com/t5/QlikView/Combine-data-from-two-sources/m-p/151190#M29095 <HTML><HEAD></HEAD><BODY><P>Hi Clara,</P><P>QlikView concatenate tables by default if the structure is the same (number of columns and exactly same names of the columns).</P><P>Firts: Check the names of the columns (upper or lower case, blank etc.).</P><P>Second: How many records you want to load?</P><P>Are you ableto download an example?</P><P>Rainer</P></BODY></HTML> Thu, 06 Aug 2009 14:02:12 GMT 2009-08-06T14:02:12Z Combine data from two sources https://community.qlik.com/t5/QlikView/Combine-data-from-two-sources/m-p/151189#M29094 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have two sources. From both the sources I get same kind of data (same columns).</P><P>I want to merge the data from the two sources and generate report out of it.</P><P>The issue I am facing.</P><P>- I am not able to use 'binary' from two qvw (for two sources) for merging as QlikView doesn't support the usage of more than one binary keyword in qvw.</P><P>- When i generate 1 qvd out from the two sources respectively and LOAD the two qvds it into a new qvw, it gets hang</P><P>- When i generate 1 qvd out from the two sources respectively and LOAD the two qvds by using concatenate keyword gives erreneous results (blanks in most columns)</P><P>- Tried some other options also, but didnt find anything that works</P><P>Please let me know if there is a way to do this....</P><P>Thanks in Advance for your help...</P><P>Regards,</P><P>Clara</P><P>Aval oru September ayirunnu....</P></BODY></HTML> Thu, 06 Aug 2009 05:10:10 GMT https://community.qlik.com/t5/QlikView/Combine-data-from-two-sources/m-p/151189#M29094 2009-08-06T05:10:10Z Combine data from two sources https://community.qlik.com/t5/QlikView/Combine-data-from-two-sources/m-p/151190#M29095 <HTML><HEAD></HEAD><BODY><P>Hi Clara,</P><P>QlikView concatenate tables by default if the structure is the same (number of columns and exactly same names of the columns).</P><P>Firts: Check the names of the columns (upper or lower case, blank etc.).</P><P>Second: How many records you want to load?</P><P>Are you ableto download an example?</P><P>Rainer</P></BODY></HTML> Thu, 06 Aug 2009 14:02:12 GMT https://community.qlik.com/t5/QlikView/Combine-data-from-two-sources/m-p/151190#M29095 2009-08-06T14:02:12Z