converting nulls to 0 for a column generated by concatanation

[sonikajain]

Hi All,

Am new to Qlikview, am stuck in a scenario where I have loaded two tables (logically one) through concatenation. now, for the columns in second table , the rows corresponding to first table have null (-s). I want to convert these to 0s wherever there is a null, right into the load script.

ISNULL isnt working as nulls are generated through non presence of values during concatenation.

Please provide sugessions.

Thanks in advance

[#2]

How many columns do are not shared between the two tables?

[#3]

use NullAsValue and NullValue.

[#4]

Juan is correct. You only need to determine the scope to which you want this behavior to apply: all tables or just these two tables. You will need a 'Set NullValue = 0;' statement and 'null as value [list of columns or *];' statement. As indicated, you can list the specific columns you want to apply the replacement to our have QV do it for all columns. You can also add a 'NullasNull' statement to revert to Qv's default null handling. The placement of the 'NullasValue' and 'NullasNull' statements will determine the tables impacted by the null replacement behavior.