fill in blank cells

novice1

Hi all,

I have data set where sales for some items are NULL. I then need to allocate store number for each record, but the records with NULL sales come back with the store number as blank. Is there a way solve the problem where all records would have store number allocated to them?

echuong1

These store values are null because they were not in one of the datasets. You can fill these in with a conditional statement. For example:

if isnull([store_number])

then [Right_store_number]

else [store_number]

endif