Logic needed for missing value

[arethaking]

Hi All,

I have two tables Table_A and TAble_B:

My current output is this:

There is no Category value for COUNTRY_B for EMPNO 240 for 5-Feb.

Required output:

I want to show for EMPNO 240 in 5-Feb.

Please help me.

Thanks in advance.

[shiveshsingh]

for your specific date, you can put calculated dimension.

=if(DATE = '2/5/2018' and  IsNull(CATEGORY),'CATEGORY_B',CATEGORY)

[krishna_2644 · Accepted solution]

Hi - i just reviewed your qvw and modified your script a bit to remove synthetic keys and duplicate fields.

also check out few comments in your script.

result: