Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
I don't think this option is available. Please correct me if I'm wrong. It would be nice to have a "quick" option to put in a column header for a field similar to how the "Alias" field is in the query builder. I realize I can build a custom statement using (TITLE 'Your Column Header'), however it would be nice to have a quicker way to do this.
Thanks
Gregg
@gregg: It's possible to make an Alias from any item in the [Select] Deck by right clicking it and choosing [Create Alias...] See the attached screenshots.
You can find more information on the SELECT Deck here Also the documentation has several illustrations on building your SQL queries efficiently. Let me know if this helps and if you have more questions on this, can you illustrate with an example, so that we can understand your use case further.
@tariqrahiman. Thank you for your reply. I am aware of the Alias option. And that works great. My issue is that I would like to create a coloumn header that will allow spaces within the name in the query builder. So instead of showing "Notes" I would like it to say "Client Notes". I am able to do this in the analyzer using the "Title" keyword (this is in Teradata").
Example:
SELECT a.mrc (TITLE 'Core MRC')
from TableMRC a
@tariqrahiman. Thank you for your reply. I am aware of the Alias option. And that works great. My issue is that I would like to create a coloumn header that will allow spaces within the name in the query builder. So instead of showing "Notes" I would like it to say "Client Notes". I am able to do this in the analyzer using the "Title" keyword (this is in Teradata").
Example:
SELECT a.mrc (TITLE 'Core MRC')
from TableMRC a
@gregg: You can use the ALIAS feature to include fields with spaces. I have attached a screenshot.
I looked into the TITLE functionality in Teradata and currently we do not have this feature. We will look into including this in a future version of ADS.
@gregg: You can use the ALIAS feature to include fields with spaces. I have attached a screenshot.
I looked into the TITLE functionality in Teradata and currently we do not have this feature. We will look into including this in a future version of ADS.
Ah. I need to use quotes to get the spaces to work. I did not realize that. That seems to work. Thank you for helping out. This solves my problem.
Gregg
Ah. I need to use quotes to get the spaces to work. I did not realize that. That seems to work. Thank you for helping out. This solves my problem.
Gregg
Issue is resolved using the ALIAS functionality. We will look into TITLE at a later stage
Issue is resolved using the ALIAS functionality. We will look into TITLE at a later stage
Issue #14530 |
| Closed |
| Won't Fix |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
@gregg: It's possible to make an Alias from any item in the [Select] Deck by right clicking it and choosing [Create Alias...] See the attached screenshots.
You can find more information on the SELECT Deck here Also the documentation has several illustrations on building your SQL queries efficiently. Let me know if this helps and if you have more questions on this, can you illustrate with an example, so that we can understand your use case further.