Latest Activity

code

Preserving VQL formatting when using Edit Mode

I generally work in the VQL mode in the Virtual DataPort tool and wish to retain my formatting. I use the "CONTEXT('formatted' = 'yes')" clause regularly, but even with that, I've noticed the formatting gets reverted back to default (including view ali...

VQL formatting

code

Want to keep formatting intact in "Field expression" window.

Is there any way to keep formatting intact in "Field expression" window while creating "New Field". I am writting my expression with proper formatting but once close and re-open I can see entire text joined in single line.

formatting

code

Setting CONTEXT ('formatted' = 'yes') as default?

Is there a way I can have the system, by defult, add "CONTEXT ('formatted' = 'yes')" to the end of a derived view when I use the VQL Shell to create views, instead of having to write it out at the end of every script?

VQL vql shell context formatting

code

Data catalog change timestamp type fields format

Hello, Currently when we query views containing fields of type "timestamp" in our Data Catalog, the data in these fields is formated in an odd way like the following example: Mon Dec 05 09:52:00 2005 When querying the same view through the VDP...

formatdate Data Catalog formatting timestamp

code

Ways to arrange fields in Derived view into folders

Hi Team We are building views in Denodo and have many fields in each of derived views and using Tableau as reporting tool. Wanted to check is there a way we can group fields in folders for view ie Sales View having folders as below as that of other se...

DENODO formatting

code

Forcing scheduled extracts to enclose all values in double quotes.

I am looking to provide a like for like file extract as a proof of concept, and the extract the users currently have enclose all the column values in double quotes. When I extract as csv using the scheduler (using denodo express 6.0), only values wher...

scheduler denodo 6.0 denodo express csv formatting