Doubt about one Dimmension

[#1]

Hi

I have two fields (they are in the same table)

Country 1: Arg, Brazil, etc

Country 2: Spain, Italia, etc.

I wanna have the dimension "Countrys" with all the values in the same field.

What should i do?

Thank ya

PD: I forgot to say that if i have Country 1 i NEVER have country 2 and if i have country 2 i NEVER have country 1. I won't have "country 1 and 2"

[saurabh5 · Accepted solution]

hi Jeremias,

you can create a new field by concatinating and then triming any tailing spaces like;

trim(Country1&Country2) as Countrys,

[fkeuroglian]

Jeremias

see this, good luck

Fernando

[#4]

Thank you! This is useful.

The "trim" worked too.

[jpapador]

If 1 is always null you could write an If statement like this:

If(Len(Country1) = 0, Country2, Country1) as Country