How to Concatenate 2 or more columns to create a listbox

[#1]

Hi Everyone,

I have a requirement where in provided with MONTH, DAY AND YEAR as separate columns create a list box concatenating all 3 columns.

INPUT:

MONTH     DAY     YEAR

JAN           02        2013

DESIRED OUTPUT:

DATE_COLUMN

2013-JAN-02

Thanks in Advance!

[Anonymous · Accepted solution]

Hi!

In List Box Properties, you can select an Expression in the "Field" comboBox, as the following picture.

In that expression, you can do something like this.

YEAR & '-' & MONTH & '-' & DAY

Other option is to create this dimension on your load, this way:

MONTH & '-' & DAY & '-' & YEAR as DATE_COLUMN

Regards,

Gabriel

[#3]

Thanks much Gabriel.. Worked like a charm!