Q&A BY TAG 'formatting'

You must sign in to ask a question. If you do not have an account, you can register here

Preserving VQL formatting when using Edit Mode
answered 03-09-2021 19:53:00 -0400

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...

Answers: 1

VQL formatting

Want to keep formatting intact in "Field expression" window.
answered 12-04-2021 08:33:16 -0400

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.

Answers: 1

formatting

Setting CONTEXT ('formatted' = 'yes') as default?
answered 24-02-2021 07:44:43 -0500

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?

Answers: 1

VQL vql shell context formatting

Data catalog change timestamp type fields format
answered 01-12-2020 07:06:36 -0500

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...

Answers: 3

formatdate Data Catalog formatting timestamp

Ways to arrange fields in Derived view into folders
answered 07-04-2017 14:04:36 -0400

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...

Answers: 2

DENODO formatting

Forcing scheduled extracts to enclose all values in double quotes.
answered 09-11-2016 12:50:28 -0500

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...

Answers: 1

scheduler denodo 6.0 denodo express csv formatting