Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Replacing Null in Joining Key column

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.

1 Reply
Highlighted
MVP
MVP

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.