I have used multiple if conditions and created a new field in script but only my first condition is working. I know this is because my first condition is coming as true and it is not going to next conditions. Is there a way i can achieve this in script?
if(product='Test3' and category='Loss','Calc_2',
))) as new_field
The above is an example i have total 16 if conditions.
I do not quite understand what you want to achieve. Match function works as OR, so if category is Loss and product is either Test1 or Test2, returns Cal_1. If this is not true, second if statement is going to be evaluated, means if category is loss and product is Test3 returns Calc_2. Once you have only 3 products (Test1,Test2,Test3), the last if statement that should return Calc_3 will be true only if category is other than Loss.
Could you please write in sentences your desired output? It might help to better understand concept.
ECG line chart is the most important visualization in your life.