topic Re: Resident Table Queries in QlikView https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065651#M945226 <HTML><HEAD></HEAD><BODY><P>You marked your own response as 'HELPFUL' . I guess I was not that helpful <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 11 Jan 2016 22:06:31 GMT sunny_talwar 2016-01-11T22:06:31Z Resident Table Queries https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065648#M945219 <HTML><HEAD></HEAD><BODY><P>I just noticed, I could not use the below syntax</P><P>RawData:</P><P>Load * Resident PreData;</P><P></P><P>To make this work, I have to trick it as follow,</P><P><SPAN style="font-size: 13.3333px;">Load *, 'X' Resident PreData;</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Is there any reason for this?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Also I could not see Resident Table structure in the Table Viewer. So, I could not see the preview of the Resident Tables.<BR /></SPAN></P></BODY></HTML> Mon, 11 Jan 2016 20:58:05 GMT https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065648#M945219 Saravanan_Desingh 2016-01-11T20:58:05Z Re: Resident Table Queries https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065649#M945222 <HTML><HEAD></HEAD><BODY><P>You can use this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #575757; font-family: arial, helvetica, sans-serif;"><STRONG>RawData:</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style=": ; color: #ff0000; font-family: arial, helvetica, sans-serif;">NoConcatenate</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="color: #575757; font-family: arial, helvetica, sans-serif;">Load *</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #575757; font-family: arial, helvetica, sans-serif;"><STRONG>Resident PreData;</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #575757; font-family: arial, helvetica, sans-serif;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #575757; font-family: arial, helvetica, sans-serif;">The reason being, when there are two tables with the same fields (exact same fieldnames), QlikView Auto-Concatenate them unless you tell it otherwise (using NoConcatenate)<STRONG><BR /></STRONG></SPAN></P></BODY></HTML> Mon, 11 Jan 2016 21:44:12 GMT https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065649#M945222 sunny_talwar 2016-01-11T21:44:12Z Re: Resident Table Queries https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065650#M945224 <HTML><HEAD></HEAD><BODY><P>Working now. Thanks Sunny</P></BODY></HTML> Mon, 11 Jan 2016 21:51:46 GMT https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065650#M945224 Saravanan_Desingh 2016-01-11T21:51:46Z Re: Resident Table Queries https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065651#M945226 <HTML><HEAD></HEAD><BODY><P>You marked your own response as 'HELPFUL' . I guess I was not that helpful <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 11 Jan 2016 22:06:31 GMT https://community.qlik.com/t5/QlikView/Resident-Table-Queries/m-p/1065651#M945226 sunny_talwar 2016-01-11T22:06:31Z