topic Re: Replacing Null in Joining Key column in QlikView

Replacing Null in Joining Key column

shyamcharan — Wed, 10 Feb 2016 00:55:35 GMT

Hi,

I have one Dimension table and other Fact table.

These two tables have a key column which is string type. I am using Autonumber() to replace the string with unique key values in both these tables and joining them with the new Autonumber() column.

However, I have noticed that the Fact table data has records with Null values. The Autonumber() is not generating any key values.

Can someone help on how to replace these null values in the key column and make proper joins?

Regards,

Shyam.

Re: Replacing Null in Joining Key column

swuehl — Wed, 10 Feb 2016 01:07:04 GMT

Your original key column showing a string shows NULL for these records?

And you want to link them to which dimensional value then?

You can test for NULL or empty using

If( Len(Trim(FIELD))=0, 'NULL', FIELD)

so you can replace NULL with an arbitrary value in your key

LOAD

Autonumber( If(Len(Trim(FIELD))=0, 'NULL', FIELD)) as KEY,

Replace the 'NULL' with the string you want to link in the dimensional table.