Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks
i have a question, i am using this expression:
num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis
i have some ZeroValue, but i am not able to convert these zero values into 'no values'
does anybody have any idea how to resolve this issue
Thanks a lot
Beck
can you explain with sample data??
try like
Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName
Regards,
can you explain with sample data??
try like
Replace(Trim(Replace(fieldName,'0',' '),' ','0') as newFieldName
Regards,
Maybe this: If(Einstandspreis>0, YourExpression) as Einstandspreis
Hi Beck,
Not quite sure I understood, but you want to have null values when the value of your Einstandspreis is zero?
If so, you can use a conditional on your load statement, like this:
Table:
Load
if (num# (Einstandspreis, '#.#', '.', ',')>0,num# (Einstandspreis, '#.#', '.', ','),null() as Einstandspreis
From [Whatever];
If your number interpretation is greate than zero, it will input null as "value".
If I misunderstood your problem, please add more to it and i'll try to help.
Felipe.
Hi Felip,
i am using this expression:
num# (Einstandspreis, '#.#', '.', ',') as Einstandspreis
and i want to replce zero-values with 'no value' and this is my problem
can you explain with sample data???
Regards,