Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Use Inline Load;
Regards
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
Not sure about your request
Maybe
US & PRA as RegApproach
Hi Robert,
Its coming like that
RegApproach
USPRA
But I need
RegApproach
US
PRA
Its not in the Table, need to create new column
RegApproach
US
PRA
Its not in the Table, need to create new column
With out using inline load is there any way
Hi Priya,
Please use below code.
TableName:
Load * inline
[
NewColumn
US,
PRA
];
Hi Max,
Yes agreed with you. But is there any way without inline load
Hi,
I Agree with Nishant, Priya we not sure how do you want the Columns, cause inline is the most Recommended one.
Regards.
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