Make 1 field from 3 fields

[#1]

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:

DOUG

BILL

TERI

CHICAGO

MEXICO

DALLAS

MARK

PAUL

TONY

RAY

RYAN

PETER

JOHN

[marthacano01]

I hope it helps you:

NewTable:

LOAD OTR as [Assigned Pricers]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD ISO as [Assigned Pricers]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD IMDL as [Assigned Pricers]

FROM

(ooxml, embedded labels, table is Sheet1);

[MarcoWedel]

Hi,

one solution could be:

table1:
LOAD *
FROM [http://community.qlik.com/servlet/JiveServlet/download/542100-109608/QlikCommunity_Thread_120861.txt] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Left Join (table1)

LOAD Distinct
  OTR,
  ISO,
  IMDL,
  AutoNumberHash128(OTR,ISO,IMDL) as %APID
Resident table1;

tabAP:
CrossTable([Assigned Pricers source], [Assigned Pricers])
LOAD Distinct
  %APID,
  OTR,
  ISO,
  IMDL
Resident table1;

hope this helps

regards

Marco

[#4]

Thank you. I’ll try it.

[#5]

Thank you. I’ll check it out, but I will need to modify it.

[#6]

Thank you. I’ll check it out.

Thank you everyone for all the suggestions. I will be working with them to get my solution.

I appreciate your time.

Paul