Denodo community Q&A RSS feedLatest Denodo community answered questionsSplit function in Derived View2024-11-11T21:16:59Z2024-11-11T21:16:59ZHello!
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?2024-11-11T21:16:59ZCache tables2024-11-08T20:50:29Z2024-11-08T20:50:29ZWhen 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 ?2024-11-08T20:50:29ZCapitalise Data Format function2024-11-07T18:41:59Z2024-11-07T18:41:59ZHi 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 possible2024-11-07T18:41:59ZExtract Numbers after each point and write in different capturing groups2024-11-06T15:53:15Z2024-11-06T15:53:15ZHi,
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 '.'2024-11-06T15:53:15ZHow to query Materialized Tables in Denodo design studio?2024-11-04T13:58:57Z2024-11-04T13:58:57ZHi,
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 advance2024-11-04T13:58:57ZREPLACEMAP and CR/LF char(10)....2024-10-31T15:02:23Z2024-10-31T15:02:23ZHi 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 ?2024-10-31T15:02:23ZCertified Developer Professional Question2024-10-28T21:10:42Z2024-10-28T21:10:42ZHi,
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!2024-10-28T21:10:42ZUnable to login2024-10-25T07:51:05Z2024-10-25T07:51:05ZI 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.2024-10-25T07:51:05ZConnectivity Issues with Denodo 8 (Design Studio)2024-10-24T19:27:23Z2024-10-24T19:27:23ZHi everyone,
I am accessing Denodo 8 (Design Studio) through the browser, and I often have to refresh the page to continue using it. It seems that somehow the browser loses connectivity with the server, but this does not happen in the Control Center. I suspect it might be related to the server or a specific configuration. Has anyone experienced this problem? Itā??s really frustrating to have to refresh the browser practically every minute. This issue occurs in Chrome, Edge, and Brave.
I would appreciate any help you can provide. Thank you!
Best regards,
Elias2024-10-24T19:27:23ZError installing Denodo 9 (Linux)2024-10-24T19:22:44Z2024-10-24T19:22:44ZHi,
Iā??m trying to install Denodo 9 (Solution Manager) on Linux, and Iā??m encountering the following error:
```
/opt/denodo9/denodo-install-solutionmanager-9$ ./install.sh
Exception in thread "main" java.lang.UnsatisfiedLinkError: /opt/denodo9/denodo-install-solutionmanager-9/jre/lib/libawt_xawt.so: libXrender.so.1: cannot open shared object file: No such file or directory
at java.base/jdk.internal.loader.NativeLibraries.load(Native Method)
at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388)
at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232)
at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174)
at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2394)
at java.base/java.lang.Runtime.load0(Runtime.java:755)
at java.base/java.lang.System.load(System.java:1957)
at java.base/jdk.internal.loader.NativeLibraries.load(Native Method)
at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388)
at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232)
at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174)
at java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315)
at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285)
at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2403)
at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818)
at java.base/java.lang.System.loadLibrary(System.java:1993)
at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1388)
at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1386)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:318)
at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1385)
at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1423)
at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1397)
at java.desktop/java.awt.Component.<clinit>(Component.java:624)
at com.izforge.izpack.installer.Installer.main(Unknown Source)
```
Has anyone faced this error? Any assistance would be greatly appreciated.
Thank you!
Best regards,
Elias2024-10-24T19:22:44Z