In Powerplay Transformer --> Dimention

[vmjoe78]

Good Morning to all,

I have a Dimention called Clint it consists of values like Master Les Ancizes, Client Heyrieux, Master Chalon etc.,

My requirement is I would like to display Master Les Ancizes to Les Ancizes, Client Heyrieux to Heyrieux etc.,
I have tried trim function, left and right funcions but that is helpless.

Could you please anyone suggest how to display it....

Master Les Ancizes --> Les Ancizes
Client Heyrieux --> Heyrieux
Master Chalon --> Chalon
MasterDuval Pamiers --> Pamiers
Master Abuert Gennevilleiers --> Gennevilleiers

Regards

Joe

[Arsenal]

if I understand correctly, you're trying to get rid of the intermediate level and just want the categories to show up..correct?
why not just use the codes that generate the categories (Les Ancizes, Heyrieux etc.) to build the dimension? Meaning, when you build your level, have the level's source code and description to the columns whose value is Les Ancizes etc. instead of using the column whose value is Master Les Ancizes etc.

[bdbits]

If you already have the values in the database as Arsenal discussed, that would be better.

If you do not have the values in the database already, you could construct calculated column expressions in Framework Manager that would work, then expose those in the Transformer model. The built-into-Transformer functions in calculated columns are unfortunately pretty limited for strings. Alternatively, you could create columns to hold the substrings during ETL, as many databases and ETL tools have a richer set of string handling functions.

[vmjoe78]

Thanks for your reply,

I have done that using Case statement in FM, I have achieved that....

Thanks for your valuable comments.

Regards

Joe