Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
for your specific date, you can put calculated dimension.
=if(DATE = '2/5/2018' and IsNull(CATEGORY),'CATEGORY_B',CATEGORY)
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: