topic Re: Quotes Removed from Alias in QlikView https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378116#M1168707 <HTML><HEAD></HEAD><BODY><P>Alexander is right, I remember reading it's something to do with the ODBC drivers here: <A _jive_internal="true" href="https://community.qlik.com/message/238088#238088">http://community.qlik.com/message/238088#238088</A></P><P></P><P>Square brackets should be used if in doubt.</P><P></P><P>Edit: This is only about the original field value though... aliases don't need quotes unless they contain spaces.</P></BODY></HTML> Wed, 15 Aug 2012 14:13:39 GMT 2012-08-15T14:13:39Z Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378113#M1168704 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I am a new user of QlikView and I have a problem. Our expert has never seen this.</P><P>I am loading data from Access tables as well as from Oracle tables. We are trying to limit the fields for linking the data in QlikView to two: Date and a Name. </P><P>The field names are not consistant in the data, so I created uniform aliases when loading the data - as an example:</P><P></P><P>Load Nm as "Name",</P><P>DT as "Date"</P><P><BR />This is where it gets odd. When I get the data loaded to QlikView, the Access data links only to other Access data, and Oracle data only to Oracle data.</P><P>The Access Table links all show the alias as entered, with the quotes ("Name", "Date"). The Oracle data shows the aliases without the quotes (Name, Date). </P><P>When I look at the tables in QlikView, both data types show filed names with the quotes.</P><P>They do not link to each other.</P><P></P><P>Can someone enlighten me as to how I can keep the quotes on the Oracle data?"</P><P><BR />Thank you!!!</P></BODY></HTML> Wed, 15 Aug 2012 12:48:21 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378113#M1168704 2012-08-15T12:48:21Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378114#M1168705 <HTML><HEAD></HEAD><BODY><P>Stupid question, but why the qoutes? They aren't needed by QV, if you need to included spaces or escape characters in your field names use square brackets instead.</P></BODY></HTML> Wed, 15 Aug 2012 13:15:48 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378114#M1168705 Alexander_Thor 2012-08-15T13:15:48Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378115#M1168706 <HTML><HEAD></HEAD><BODY><P>I think Oracle loads all field names in Uppercase. And since Field names are case sensitive in QlikView, fields do not get associated.</P><P></P><P>This is helpfull of course if you removed the quotes and it still does not work.</P></BODY></HTML> Wed, 15 Aug 2012 14:12:08 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378115#M1168706 giakoum 2012-08-15T14:12:08Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378116#M1168707 <HTML><HEAD></HEAD><BODY><P>Alexander is right, I remember reading it's something to do with the ODBC drivers here: <A _jive_internal="true" href="https://community.qlik.com/message/238088#238088">http://community.qlik.com/message/238088#238088</A></P><P></P><P>Square brackets should be used if in doubt.</P><P></P><P>Edit: This is only about the original field value though... aliases don't need quotes unless they contain spaces.</P></BODY></HTML> Wed, 15 Aug 2012 14:13:39 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378116#M1168707 2012-08-15T14:13:39Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378117#M1168708 <HTML><HEAD></HEAD><BODY><P>Thank you!</P><P></P><P>Andy Schmidt</P><P>HealthPartners Dental Clinic Operations</P><P>952-883-7734</P><P>andrew.m.schmidt@healthpartners.com</P></BODY></HTML> Wed, 15 Aug 2012 16:19:51 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378117#M1168708 2012-08-15T16:19:51Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378118#M1168709 <HTML><HEAD></HEAD><BODY><P>Thank you for the information – I’m new to this and had no idea I could use brackets…</P><P>Very helpful</P><P></P><P>Andy Schmidt</P></BODY></HTML> Wed, 15 Aug 2012 16:20:27 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378118#M1168709 2012-08-15T16:20:27Z Re: Quotes Removed from Alias https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378119#M1168710 <HTML><HEAD></HEAD><BODY><P>Thank you for the information – I’m new to this and had no idea I could use brackets…</P><P>Very helpful!</P><P></P><P>Andy Schmidt</P></BODY></HTML> Wed, 15 Aug 2012 16:21:03 GMT https://community.qlik.com/t5/QlikView/Quotes-Removed-from-Alias/m-p/378119#M1168710 2012-08-15T16:21:03Z