If condition issue

[sunny_talwar]

Try this:

LOAD MESSAGE_CODE

     MESSAGE_DESC,

   if(Len(Trim(MESSAGE_DESC))>0, MESSAGE_DESC,MESSAGE_CODE)) as Details

FROM $(path)MESSAGE_CODES.qvd;

[sunny_talwar]

I have no idea how this thread got created

[marcus_sommer]

Have you answered to this posting from inside the inbox? I have had several times strange results if I did posting from inside the inbox and the answers was going elsewhere - therefore I try to avoid it by opening a post each time within a new tab.

- Marcus

[sunny_talwar]

I did not reply to the posting from inside the inbox. Its strange that this response was earlier available inside the original post and it later came up as another post. Funny part is that I am unauthorized to delete this