How to combine 2 different fields to make them one dimension instead of two

[#1]

How to combine 2 different fields to make them one dimension instead of two

[datanibbler]

Hi abdallah,

the easiest way would  be to concatenate them into one "compount_field" in a LOAD_statement, using the &

LOAD

   ...

   ([field1] & '|' & [field2]) as [new_dimension]

   ...

FROM

...

Of  course, you could do the same on the GUI.

HTH

Best regards,

DataNibbler

[cspencer3]

you could combine them in the load script as:

Load

Field1&Field2 as NewField

;

(You could also add a character separator if it would be more meaningful)

or you can use a calculated dimension and do the same thing as the load script, just use that syntax in your calculated dimension.

[#4]

thank you very much!

[cspencer3]

Delay between me typing and posting; DataNibbler beat me to it.