Assigning text in a table

[#1]

Hi Guys

From the table below, I have the Customer and Costs columns as dimensions. What I want to achieve is get a column called Description and assign the following descriptions as shown in the Description column. Please any help on how to figure these out?

Customer              Costs                Description       

HighElectro              € 1,924,11        Regular costs

HighElectro                € 353,32        Rental costs

HighElectro                  €  79,33        Connection costs

HighElectro                  €354,00        Other costs

HighElectro                  €119,48        Other costs

Thanks.

[Anonymous]

Hi

Assuming there is some logic based on the costs column to define what the description should be you could apply that logic in your load script for example:

If(Costs=  € 1,924,11,'Regular costs',etc) as description or you could create a mapping table if you have a few costs to apply a description to. It is difficult to suggest the best way without a more detailed outline of your requirements.

Kindest Regards

Brian

[varshavig12]

Inline load

[Mark_Little · Accepted solution]

Hi Simon,

What people would need to know is how each of he descriptions are defined. I.e. if cost is a certain amount then or if it is a certain customer type...

The Logic will be something like

IF( SUM(Costs) > 100, 'Connection costs',

     IF(....

Mark

[Anonymous]

if you have nothing else than your 2 dimensions,

you may hardcode your desired column

if (Costs=1924.11, 'Regular Costs',

  if (Costs=353.32, 'Rental Costs',

    if (Costs='79.3','Connection Costs',

       ....

But you only get what you want. This is not a good solution!!

you need something different  as e.g. a category to identify the different costs

[MindaugasBacius]

How do the cost appear? Is it from ledger?

[#7]

Thank you all for your help. I will try to use your suggestions and adapt my needs

[#8]

Thanks for the help I will try to use your suggestion as adapt my needs

[#9]

Thanks Mark, I will try to use your suggestion and see how to achieve what I need