Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
hi Jeremias,
you can create a new field by concatinating and then triming any tailing spaces like;
trim(Country1&Country2) as Countrys,
hi Jeremias,
you can create a new field by concatinating and then triming any tailing spaces like;
trim(Country1&Country2) as Countrys,
Jeremias
see this, good luck
Fernando
Thank you! This is useful.
The "trim" worked too.
If 1 is always null you could write an If statement like this:
If(Len(Country1) = 0, Country2, Country1) as Country