Discussion Board for collaboration on QlikView Scripting.
I have three fields in an Excel file: OTR, ISO, IMDL.
OTR has values of DOUG, BILL, TERI, CHICAGO, MEXICO, DALLAS
ISO has values of MARK, PAUL, TONY, RAY
IMDL has values of RYAN, PETER, JOHN
I want to make one field called Assigned Pricers (the field will be used
as a dropdown box to allow my dashboard users to select the Pricer).
I want it to look like the following:
The fields are valued as my example shows. However,
the fields are valued as such on the excel file.
OTR ISO IMDL
CHICAGO TONY PETER
- a test table, Transactions with your data (OTR, ISO,MDL)
- a table with [Assigned Pricers] field
load *, rowno() as id;
mod(TransID,26)+1 as Num,
Pick(Ceil(6*Rand1),'DOUG', 'BILL', 'TERI', 'CHICAGO', 'MEXICO', 'DALLAS') as OTR,
Pick(Ceil(4*Rand1),'MARK', 'PAUL', 'TONY', 'RAY') as ISO,
Pick(Ceil(3*Rand()),'RYAN', 'PETER', 'JOHN') as IMDL,
Round(1000*Rand()*Rand()*Rand1) as Expression1;
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
While Rand()<=0.5 or IterNo()=1;
load distinct id, OTR as [Assigned Pricers] Resident Transactions;
Concatenate (Table) load distinct id, ISO as [Assigned Pricers] Resident Transactions;
Concatenate (Table) load distinct id, IMDL as [Assigned Pricers] Resident Transactions;