Creatin Column

[priyarane]

Hi Experts,

How to create a new column with 2 Fieds like below.

Tab:

Name,

Dept

From

C:Tab\Tab.qvd;

I want the new column needs to add with 2 fields

Like -

RegApproach(New Column)

US

PRA

I tried like below

Tab:

Name,

Dept,

'US' as RegApproach

From

C:Tab\Tab.qvd;

But I can't add PRA field

[PrashantSangle]

Hi,

Use Inline Load;

Regards

[datanibbler]

Hi Priya,

I don't quite get it - so you want a new field (column) with two values, US and PRA?

Is there some pattern (rgd. some other field) telling you which records should have US and which should have PRA?

=> in that case, you could just do two LOADs, each with a WHERE function - and do just like you already have.

HTH

[robert_mika]

Not sure about your request

Maybe

US & PRA as RegApproach

[priyarane]

Hi Robert,

Its coming like that

RegApproach

USPRA

But I need

RegApproach

US

PRA

Its not in the Table, need to create new column

[priyarane]

RegApproach

US

PRA

Its not in the Table, need to create new column

With out using inline load is there any way

[Anonymous]

Hi Priya,

Please use below code.

TableName:

Load * inline

[

NewColumn

US,

PRA

];

[priyarane]

Hi Max,

Yes agreed with you. But is there any way without inline load

[#9]

Hi,

I Agree with  Nishant, Priya we not sure how do you want the Columns, cause inline is the most Recommended one.

Regards.

[Anonymous]

Create an empty field first.

Assign PRA and USA value to it by using below function.

ValueList will simple display a list of values inside the ()

Valuelist function for Synthetic/dummy dimension

/docs/DOC-5011