Excel type of Macro to the DataPrep - it is multicondition macro.

[Doti]

hello, I am looking on the best approach to bring the Excel type of Macro to the DataPrep - it is multicondition macro. example: 

=IF(AQ3="",50,IF(AQ3>1000,25,IF(AND(AQ3<1001,AQ3>100),20,IF(AND(AQ3<101,AQ3>50),15,IF(AND(AQ3<51,AQ3>25),10,5)))))*2

any tips

[Trifacta_Alumni]

Thank you for reaching out.

You can use CASE statements here. Below is a screen shot for reference.

Happy Wrangling!

Best,

Rachana

[Trifacta_Alumni]

CASE([AQ3 > 1000, 25, (AQ3 > 100 && AQ3 < 1001), 20, (AQ3 > 50 && AQ3 < 101), 15, (AQ3 > 25 && AQ3 < 51), 10, 5])

Please feel free to learn more at https://docs.trifacta.com/display/DP/CASE+Function

Best,

Rachana