Q&A BY TAG 'COLUMN_DESCRIPTION'

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

Add Column Description doesn't work with UNION
answered 31-05-2022 05:03:40 -0400

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = 'xxx' (columnname (DESCRIPTION = 'xxx')), it will give me an error saying the firl...

Answers: 1

COLUMN_DESCRIPTION UNION

Add Column Description doesn't work with UNION when appending record
answered 31-05-2022 05:01:43 -0400

I am trying to append a specific record to a derived view with UNION. The view can be created without DESCRIPTION. But when I do CREATE OR REPLACE VIEW xxx DESCRIPTION = ‘xxx’ (columnname (DESCRIPTION = ‘xxx’)), it will give me an error saying the firl...

Answers: 1

COLUMN_DESCRIPTION UNION

how to do the transpose columns to rows as two separate columns
answered 10-06-2020 04:27:10 -0400

Hi All, I have to do transpose data columns to rows like below currently data is showing like this: ID date Q1 Q2 1 01-03-2020 00:00 6 9 2 13-03-2020 00:00 7 8 Expected output: ID date Questions Answers 1 01-03-2020 00:00 Q1 6 2 01-03-2020 00:00 ...

Answers: 1

DENODO COLUMN_DESCRIPTION

Display column description INSTEAD of column name
answered 01-02-2019 04:33:15 -0500

When building views for our business I want to display COLUMN_DESCRIPTION not column names in my views and reports. How can I display COLUMN_DESCRIPTION instead of COLUMN_NAMES in views derived from iv_views?

Answers: 1

COLUMN_DESCRIPTION