topic load two different field names as one name in QlikView

load two different field names as one name

renjithpl — Fri, 12 Nov 2010 07:55:38 GMT

Hi all,

I need a help in my load script, i have a table like below;

Name	Country	Add1	Add2
Steve	Germany	xxx	xxx
Mike	Belgium	abc	yyy

I want a field called "Address" with Add1 & Add2, so when i select "Address" it should show two option (Add1 and Add2).

i have tried something like this,

Directory;

LOAD Name,

Country,

Add1,

Add2,

(Add1 & Add2) as Address

FROM

[Phase 1 Testing.xlsx]

(ooxml, embedded labels, table is Categories);

since my first row of table has same data in Add1 and Add2 (xyz1), its showing some wierd result.

Please help in giving the right solution. Thanks in Advance.

Renjith

load two different field names as one name

deepakk — Fri, 12 Nov 2010 08:01:05 GMT

Try putting some special characters eg"

add1 & '-' & add2

add1 & ' ' & add2

load two different field names as one name

renjithpl — Fri, 12 Nov 2010 08:16:03 GMT

thanks for your reply dude, it dint work,

i will rephrase it once again clearly, below is my actual table,

SubCategory	MgdReview	GdedReview
Platform ease of Use	Managed Review	Guided Review
Platform operational speed	Managed Review	Guided Review
Doc-to-doc browsing speed	Managed Review

Basically in "MgdReview" there will always Managed Review and in "GdedReview" there will be always Guided Review,

i want to have a field called "Review Modes" in the list box when i call it, it should display 1. Managed Review 2. Guided Review

is it possible or any other suggestion.?

load two different field names as one name

Fri, 12 Nov 2010 08:19:38 GMT

Use 'Join' for joining the Add1 and Add2,if your purpose is to show both the fields together.

load two different field names as one name

Miguel_Angel_Baeyens — Fri, 12 Nov 2010 08:30:17 GMT

Hello Ranjit,

I'd use a Crosstable here, following this example

Subcategories:LOAD * INLINE [SubCategory, MgdReview, GdedReviewPlatform ease of Use, Managed Review, Guided ReviewPlatform operational speed, Managed Review, Guided ReviewDoc-to-doc browsing speed, Managed Review]; CROSSTABLE (FieldName, [Review Modes]) LOAD *RESIDENT Subcategories; DROP TABLE Subcategories;DROP FIELD FieldName; //Since you don't use the "MgdReview" and "GdedReview" fieldnames

You can find another sample code here.

Hope that helps.

load two different field names as one name

deepakk — Fri, 12 Nov 2010 08:40:28 GMT

HI Ranjit,

If you are looking at hierarchy kind of a scenario then check out this forum..

http://community.qlik.com/forums/p/27820/107479.aspx

load two different field names as one name

renjithpl — Fri, 12 Nov 2010 12:51:59 GMT

hi Miguel,

i made it worked using a crosstable. THanks a lot. and thanks deepak for your reply.

Regards