topic Re: How to combine two field into 1 in QlikView

How to combine two field into 1

sarfaraz_sheikh — Wed, 12 Aug 2015 10:37:53 GMT

Dear All,

I have two fields name it as follows

1> Ergo_Location

2> ERGO_LOC

I am getting expected result from both the option..However i needs to combine both these field into one

for ex. Ergo_Location giving me 100 count of Leads where as ERGO_LOC giving me 200 Leads count

so i need to show the Ergo_Loc is giving me 300 leads count

As of now i am using both the option as dimension ....and my requirement is to combine these 2 dimension and make them as 1 dimension.

If it is possible then please advice me

Sarfaraz

awhitfield — Wed, 12 Aug 2015 10:39:44 GMT

Hi,

why not rename one of the fields in your load script?

Ergo_Location As ERGO_LOC

Andy

sunny_talwar — Wed, 12 Aug 2015 10:41:28 GMT

Maybe this:

Table:

LOAD Ergo_Location,

OtherFields

Resident AboveTable

Where Len(Trim(Ergo_Location)) > 0;

Concatenate (Table)

LOAD ERGO_LOC as Ergo_Location,

OtherFields

Resident AboveTable

Where Len(Trim(ERGO_LOC)) > 0;

DROP Table AboveTable;