Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Currently reciving a file daily and I need to calculate some stuff from it and then save that to a QVD.
Expressions are loaded from excel and used in pivot.
When I do this
load
'=$(vM_Merchants_ant)' as meracants
AutoGenerate 1;
I save the expression, I need to save the result.
The structure is:
If vxM_Merchants_ant <>'' then
Let vxM_Merchants_ant=vxM_Merchants_ant (why want to do this??);
Else
Let vxM_Merchants_ant='';
End If;
But, this conditional has 2 contradictions:
- If V<>'' then V=V?????
- if V='' THEN V="" (the second chance of IF will occur when the condition is false, or the opposite of the condicion is true, like this case)
Sorry for my bad engrlish, but i cant understand what you needs... Try to explain better please.