I have the following data that I am importing and need to return a certain value in SWEEP_STATUS if the CUST_NBR matches a certain customer, but if it does not match I just want the normal results. Here is my script and it is telling me garbage after load. What am I doing wrong? nd do I have the IF THEN statement in the right place to begin with?
COMMITMENT_ID, SWEEP_STAT, CUST_NBR, FROM [$(vFromQVD)\HRC_LIABILITIES.qvd](qvd)
IF(([CUST_NBR] = '0450011670') THEN ([SWEEP_STATUS]='Yes'));
Store HRC_LIABILITIES_ORIGINAL into [$(vToQVD)\HRC_LIABILITIES_SWEEP_STATUS_CHANGE.qvd](qvd);
Will this make my SWEEP_STAT populate as 'No' for everything else that is not that particular customer? Because some could be yes and others no and I want both in there, but I just want that specific customer to all be 'Yes'.