Discussion Board for collaboration on QlikView Scripting.
How to create a new column with 2 Fieds like below.
I want the new column needs to add with 2 fields
I tried like below
'US' as RegApproach
But I can't add PRA field
Use Inline Load;
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.
Not sure about your request
US & PRA as RegApproach
Its coming like that
But I need
Its not in the Table, need to create new column
With out using inline load is there any way
Please use below code.
Load * inline
Yes agreed with you. But is there any way without inline load
I Agree with Nishant, Priya we not sure how do you want the Columns, cause inline is the most Recommended one.
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