IF Conditions

[meziane36u]

how to make several conditions, for example if the value = 1 then Normal, for all fields?

1 - Normal

2 - Light rain

3 - Heavy rain

4 - Snow - hail

5 - Fog - smoke

6 - Strong wind - storm

7 - Dazzling weather

8 - Cloudy weather

9 - Other

[Emil_Kos]

Hi @meziane36u,

I would suggest a combination of the Transpose + find and replace tool. Find and replace is better than formula tool as it is easier to maintain. 

In the end, I am using a cross tab to transform the data into the old format.

Please mark my solution if this was helpful.

Good luck!

[Tyro_abc]

Hi @meziane36u 

Please check the attached workflow and let me know if this is what you are looking for.

I used Switch Case inside the Multi-Field Formula tool to achieve the same. 

[meziane36u]

thank you all i fixed the problem using formula