Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

reserved words

newbie question, I am pulling a table from sqlanywhere and using the tDbinput with a built in schema. in the schema entry one of the column names is "private"  which is shown as an invalid entry in the column name entry.   How can I wrap this at that point in order to extract that column?

 

Labels (1)
2 Replies
Anonymous
Not applicable
Author

0683p000009M4FI.png

Anonymous
Not applicable
Author

I figured out the answer and maybe this will help someone else. I put private1 in the column and private in the dbcolumn where it seemed to then work. I then put ` private` in the sql query i created at the bottom of the component where you can put in your query. And it pulled that column fine