Setting a default value on a column within a load statement
Hi. I want to be able to set a default to the "Partner" column if it is null in the attributes QVD. How is that accomplished within the load statements? If it's blank or null, I want to populate it with "Other". Thank you in advance.
Re: Setting a default value on a column within a load statement
Since you want to a column 'Partner' to another table, I would suggest not to use LEFT JOIN, but a MAPPING solution (with the benefit to easily define a default value), this will even work if the record in the Attributes.qvd is completely missing.