I have the following script that converts null values to zeros in the load editor. However, I don't know how many columns I might have in a future file. Is there any way to create some type of loop to perform this on all columns.
That works. However, I'm not sure what to switch it back to null values. So currently I have my above statement replaced with:
Set NullValue = 0;
I'm not sure how to switch it back to nulls showing up as nulls
Set NullValue = Null();
but it's converting my null values to 'Null()' string. Which isn't what I want, can you help me how to change it back to representing nulls as nulls?
After my new statement and it seems to be converting all the nulls in Table1 & Table1_v2 back to null, I was hoping to see that Table1 would have zeros and Table1_v2 would have null. Just to ensure I know how to turn nulls back on.
I don't know what you're exactly trying, but if I remember it correctly, NullasNull/NullasValue works only for loaded fields, not for missing fields that will be converted into null() values when joining or concatenating. Then you must do a further resident load...
It looks like my edit and issue seems to have to do with the fact that I was using the same table. Overall I got an example of data to work and I understand how these items work better now. I really appreciate both of ya'll responses.
Here's a sample set of data I used to understand how this is working in case it's helpful to someone else later: