Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions Code Structure https://community.denodo.com/answers/question/details?questionId=906Qj00000MWozbIAD&title=Code+Structure denodo. i am designing nicely structured and formatted code. when i open the code again it is all in just one line. how can i resolve this issue Tue, 12 Nov 2024 11:55:32 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MWozbIAD&title=Code+Structure 2024-11-12T11:55:32Z Split function in Derived View https://community.denodo.com/answers/question/details?questionId=906Qj00000MTnLfIAL&title=Split+function+in+Derived+View Hello! I have created a derived view in which, for one of the field, I have a requirement to strip a part of the string. That is, I have a string "domain_name\first_name" in one of the fields and am trying to create a new field by taking only the first_name and append "@gmail.com" at the end. The new column would look like 'first_name@gmail.com'. I tried using SPLIT function to split the string using "\", but that gives me an array and am not able to take just one element in the array. Is there a better way of doing it? Mon, 11 Nov 2024 21:16:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MTnLfIAL&title=Split+function+in+Derived+View 2024-11-11T21:16:59Z Special characters (ü; ..) are not display correctly from the reporting system https://community.denodo.com/answers/question/details?questionId=906Qj00000MS8Z7IAL&title=Special+characters+%28%26uuml%3B%3B+..%29++are+not+display+correctly+from+the+reporting+system Hello, i hope someone can help me. I have display problems with certain special characters in a report. I mean letters like ä ö My problem is, that this letters are displayed correctly in my source : LDAP Apache Directory https://ibb.co/z6YyDgK They are correct, if i get this data inside denodo. It looks like this. https://ibb.co/wRnLJHY But in the reporting system, i get for the letters a wrong display ü --> Ã?¼ ä --> Ã?¤ From this website you see other characters: https://www.designerinaction.de/tipps-tricks/web-development/html-umlaute-sonderzeichen/ This is the result: https://ibb.co/9Yx4M2D I do a simple select * from denodo_view Query: SELECT * FROM inetorgperson LIMIT 150 CONTEXT ('i18n'='us_pst', 'cache_wait_for_load'='true') TRACE I think it is a UTF-8 or codepage problem. Other reports from our reporting system can display the letters correct, if they come from a database like ms sql server or teradata. Has someone an idea, how i can change the output to get the correct display of the special letters? Maybe a option inside the odbc64 driver or the select statement can be changed?! Or maybe this setting can be helpful? https://ibb.co/gWQWW9K Regards Mon, 11 Nov 2024 13:49:02 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MS8Z7IAL&title=Special+characters+%28%26uuml%3B%3B+..%29++are+not+display+correctly+from+the+reporting+system 2024-11-11T13:49:02Z Cache tables https://community.denodo.com/answers/question/details?questionId=906Qj00000MJESSIA5&title=Cache+tables When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Similar question was asked in 2017 but not sure if anything has been changed in Denodo 8 to allow name change ? Fri, 08 Nov 2024 20:50:29 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MJESSIA5&title=Cache+tables 2024-11-08T20:50:29Z Capitalise Data Format function https://community.denodo.com/answers/question/details?questionId=906Qj00000MD1fyIAD&title=Capitalise+Data+Format+function Hi there, I have a string file. "This is the test message" . I would liket to capitalise the first letter of each word. the expected outcome is "This Is The Test Message" Is this possible Thu, 07 Nov 2024 18:41:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000MD1fyIAD&title=Capitalise+Data+Format+function 2024-11-07T18:41:59Z Extract Numbers after each point and write in different capturing groups https://community.denodo.com/answers/question/details?questionId=906Qj00000M5VEhIAN&title=Extract+Numbers+after+each+point+and+write+in+different+capturing+groups Hi, i am struggeling with the follwing problem: Input String "1.2.3.4.5" -> Result "Value: 1 2 3 4" REGEXP('1.2.3.4.5.', 'dont know how to do this', 'Value: $1') Important is that i can set the Numbers of results i will receive. e.g. when i Set 3 Input String "1.2.3.4.5" -> Result "Value: 1 2 3" Can someone help with this Problem ? Edit: i created this regex (solved) ``` REGEXP('1.2.3.4.5', '(\.*\d+\.*)$', '') ``` It Extracts only the the first 4 (or 3, or 2) and deletes the last Value after the '.' Wed, 06 Nov 2024 15:53:15 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000M5VEhIAN&title=Extract+Numbers+after+each+point+and+write+in+different+capturing+groups 2024-11-06T15:53:15Z How to query Materialized Tables in Denodo design studio? https://community.denodo.com/answers/question/details?questionId=906Qj00000LtNchIAF&title=How+to+query+Materialized+Tables+in+Denodo+design+studio%3F Hi, New to Denodo, I want to create a Materialized Table and then use it with a base view to create a integrated view. I have created the Materialized Table using 'Create Materialized Table' query but I dont see it in virtual database. And also if I run a Select query in VQL on this Materialized Table, I get error 'Table not found'. But If I try to create the table again, it says 'Table already exists'. Please help me understand how to work with Materialized Tables? Thanks in advance Mon, 04 Nov 2024 13:58:57 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LtNchIAF&title=How+to+query+Materialized+Tables+in+Denodo+design+studio%3F 2024-11-04T13:58:57Z REPLACEMAP and CR/LF char(10).... https://community.denodo.com/answers/question/details?questionId=906Qj00000LgPZ2IAN&title=REPLACEMAP+and+CR%2FLF+char%2810%29.... Hi Denodo Team, i want to Replace CR and LF in some columns. With Replace this is no Problem and working fine. ``` REPLACE(REPLACE(column1, char(10), ''), char(13),'') ``` But for future use i want a MAP for this. ``` CREATE MAP simple forbidden_chars ( 'char(10)' = '' 'char(13)' = '' ); ``` this is not working. how can I do this with a map ? And how can i Change a map ? Do i have to drop it first ? Thu, 31 Oct 2024 15:02:23 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LgPZ2IAN&title=REPLACEMAP+and+CR%2FLF+char%2810%29.... 2024-10-31T15:02:23Z Certified Developer Professional Question https://community.denodo.com/answers/question/details?questionId=906Qj00000LUcDRIA1&title=Certified+Developer+Professional+Question Hi, I'm interested in taking all the training courses for the Certified Developer Professional. But looks like the training courses listed above have some for Denodo 9.0 and some for 8.0. Wondering if someone could help understand the approach of taking the courses(if those are going to change soon etc.) Thanks! Mon, 28 Oct 2024 21:10:42 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LUcDRIA1&title=Certified+Developer+Professional+Question 2024-10-28T21:10:42Z Unable to login https://community.denodo.com/answers/question/details?questionId=906Qj00000LKT1lIAH&title=Unable+to+login I have just installed express version of denodo. I don't remeber about User Name. I got secuirtycode via email and then entered password. Now it is asking user name. I am typing my email ID as User name but is giving an error. Invalid user / Password. Please advice. Fri, 25 Oct 2024 07:51:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LKT1lIAH&title=Unable+to+login 2024-10-25T07:51:05Z