Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load the data from external QVD files. Some records there contain empty cells. What would be the best way to detect these cells and fill them with some data ("EMPTY" for string and "0000" for number, for example).
I would appreciate an expert advice.
Best regards,
VK.
Vladimir,
Not sure why you need it to be dual ('EMPTY' and 0), but, assuming you want to convert null values of a field into the required values, you can do it this way:
if(len(trim(field))=0, dual('EMPTY',0), field) as field
Vladimir,
Not sure why you need it to be dual ('EMPTY' and 0), but, assuming you want to convert null values of a field into the required values, you can do it this way:
if(len(trim(field))=0, dual('EMPTY',0), field) as field
Michael,
Thanks for the suggestion. It works perfectly (I am not very concerned about loading time since my system is set to run reload once a day during after-hours).
Regards,
VK