This statement is not working for me.
Anyone got a clue of what is wrong?
If("t_invc"=1 and "t_rtrn"=0,1,0) as Flag_InternalSales, // 1=Yes,0=No
Remove the quotes Freddy
If(t_invc=1 and t_rtrn=0,1,0) as Flag_InternalSales
Hi, thanks for the input. Do not work to remove quotes as the data model has these quotes from the database.
hello try so If(t_invc=1 or t_rtrn=0,1,0) as Flag_InternalSales
Hi. Sorry guys. "t_rtrn" do not have 0 as a value. Only 1 and 2. That explains it. Thanks again.
I'm not sure about the quotes, I would remove them in load script.
If not possible you can try if this helps (not sure):
If(["t_invc"]=1 and ["t_rtrn"]=0,1,0) as Flag_InternalSales
Try with this:
If("t_invc"=1, if("t_rtrn"=0,1,0)) as Flag_InternalSales, // 1=Yes,0=No
Retrieving data ...