How to combine two field into 1

[sarfaraz_sheikh]

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]

Hi,

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

Ergo_Location As ERGO_LOC

Andy

[sunny_talwar]

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;