Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 columns Gross revenue and net revenue and 3rd column customer type where some charater values are there. I need to create new gross and new net columns based on some condition using customer type. How can i use multiple if statement in edit script for this? Any help appreciated
Hi Jagan,
I dont know why but for some reason this syntax is only copying for Gross for Indirect customers. For Direct customers and for some other conditions i have the gross is still showing 0.
Regards,
Mallik
Hi Shyamal,
I dont know why but for some reason this syntax is only copying for Gross for Indirect customers. For Direct customers and for some other conditions i have the gross is still showing 0.
Regards,
Mallik
Hi Nirmal,
I dont know why but for some reason this syntax is only copying for Gross for Indirect customers. For Direct customers and for some other conditions i have the gross is still showing 0.
Regards,
Mallik
Hi Tresesco,
I dont know why but for some reason this syntax is only copying for Gross for Indirect customers. For Direct customers and for some other conditions i have the gross is still showing 0.
Regards,
Mallik
Check these:
If the parenthesis are proper, or comparison string/field name is correct. Or, you might want to share a sample app.
You can check for the paranthesis or post a sample app, so it would be easier to pin point the issue.
YOU CAN ACHIEVE THIS IN TWO STEP-
during 1st load-
LOAD
*,
If( [Customer type] = 'Indirect', 1,0) as GrossF1,
If([Custmer type] = 'direct' and [Book Type]='Standard' and [Action type]='Fixed', 1,0) as GrossF2
during 2nd load take resident of above table and try below code
load *,
if(GrossF1=1 or GrossF2=1,Gross) as new gross
hope this will help