load two different field names as one name

[renjithpl]

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

[deepakk]

Try putting some special characters eg"

add1 & '-' & add2

add1 & ' ' & add2

[renjithpl]

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.?

[#4]

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

[Miguel_Angel_Baeyens · Accepted solution]

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.

[deepakk]

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

[renjithpl]

hi Miguel,

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

Regards