topic Re: Three Fields into one field in QlikView

Three Fields into one field

Wed, 04 Jun 2014 16:50:51 GMT

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 with values (the field will

be used as a dropdown box to allow my dashboard users to select the Pricer):

I want oit to look like the following:

DOUG

BILL

TERI

CHICAGO

MEXICO

DALLAS

MARK

PAUL

TONY

RAY

RYAN

PETER

JOHN

Re: Three Fields into one field

Wed, 04 Jun 2014 18:57:03 GMT

It is possible to accomplish this through the use of the Crosstable function in the script. I am not sure how your data is formatted in Excel, but a quick test of the following provided the new "Pricer" field as you are looking for...

CreatePricer:

Crosstable(Col2,Pricer)
LOAD * INLINE [
Col1, Col2
OTR, Doug
OTR, Bill
OTR, Teri
OTR, Chicago
OTR, Mexico
OTR, Dallas
ISO, Mark
ISO, Paul
ISO, Tony
ISO, Ray
IMDL, Ryan
IMDL, Peter
IMDL, John
];

Good luck

Re: Three Fields into one field

maxgro — Wed, 04 Jun 2014 19:15:11 GMT

did you check the answers for (it seems to me) the same request

Make 1 field from 3 fields

Re: Three Fields into one field

Wed, 04 Jun 2014 19:24:36 GMT

It turned out I had duplicate requests. Sorry.