topic Re: Merging Data into a field in QlikView

Merging Data into a field

Wed, 01 Jun 2011 11:11:50 GMT

Hello everyone,

Is it possible to take two text fields and map them together

e.g. Item + product = itemproduct so it produces a unique field to map against in another table (which i've created separately)

these are in two separate tables

audicar

auditruck

audilorry

bmwcar

bmwtruck

bmwlorry

fordcar

fordtruck

fordlorry

so every time audi and car appear it is audicar

Thank you for your time

Merging Data into a field

Wed, 01 Jun 2011 11:24:17 GMT

try:

item&product as itemproduct

Merging Data into a field

Wed, 01 Jun 2011 11:37:15 GMT

Thanks for your reply. Where would I put this syntax? Will this work for two different tables?

Table 1 has the item in and table 2 has the product in.

Merging Data into a field

Wed, 01 Jun 2011 11:49:18 GMT

I guess not. It's working only these field in 1 table. So i think you should join these 2 tables.

Give us some example or something.

Re: Merging Data into a field

Wed, 01 Jun 2011 12:05:05 GMT

one table has departments and amounts, and the other has industry codes in and i've created this table below. what I need is department and industry codes so I can map it to other tables as a unique identifier. at the moment there is no unique id that says FRT and CAR= FRT commercial

The idea is to select FRT commercial and just get a total of all the FRT commercial. problem is that when I select FRT commercial now I get the total of FRT and any industry that has aviation car cater charity in it (i.e. a total of everything)

ID	Department	Industry Code	Industry Description	New Department
FRTAVIATION	FRT	AVIATION	Aviation - NOT OPERATORS	FRT Commercial
FRTCAR	FRT	CAR	Car / Motor-related Co s	FRT Commercial
FRTCATER	FRT	CATER	Catering	FRT Commercial
FRTCHARITY	FRT	CHARITY	Charities and foundations	FRT Government
FRTTCAVIATION	FRTTC	AVIATION	Aviation - NOT OPERATORS	FRT Time Critical
FRTTCCAR	FRTTC	CAR	Car / Motor-related Co s	FRT Time Critical
FRTTCCATER	FRTTC	CATER	Catering	FRT Time Critical
FRTTCCHARITY	FRTTC	CHARITY	Charities and foundations	FRT Time Critical
CADAVIATION	CAD	AVIATION	Aviation - NOT OPERATORS	CJ Other
CADCAR	CAD	CAR	Car / Motor-related Co s	CJ Other
CADCATER	CAD	CATER	Catering	CJ Other
CADCHARITY	CAD	CHARITY	Charities and foundations	CJ Other
EADAVIATION	EAD	AVIATION	Aviation - NOT OPERATORS	PJ ADHOC
EADCAR	EAD	CAR	Car / Motor-related Co s	PJ ADHOC
EADCATER	EAD	CATER	Catering	PJ ADHOC
EADCHARITY	EAD	CHARITY	Charities and foundations	PJ ADHOC