Transforming data following criterias

[#1]

Hello everyone,

Here is the situation :

• I have a data table containing approximately 300'000 rows
• I have a field named idOperation which have values between 1 and 6
• I need to transform my data differently for each value of idOperation
  • There are other criterias for every value of idOperation

Here is my question, what is the best way to achieve this ? I thought of something like this, but I really hope there are better solutions.

Thank you in advance.

[marcus_sommer]

I think I would do something like the following:

load

     *,

     pick(match(idOperation, 1,2,3,4,5,6),

          Transformation1,

          Transformation2,

          ...) as New

from qvd;

- Marcus

[#3]

Thanks for your answer, I actually have more than one transformation to do for each idOperation.
The fastest way I've found to achieve this is making LOADs for each case with WHERE clauses.