Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help to show blank instead of hyphen where there is no possible values, the product 4 has no row in the fact, so it shows a hyphen in the straight table:
fact:
LOAD * inline [
product,tag,date,key
P_1,T_1,01/01/2001,P_101/01/2001
P_1,T_1,15/01/2001,P_115/01/2001
P_1,T_1,31/01/2001,P_131/01/2001
P_2,T_2,01/02/2002,P_201/02/2002
P_3,T_1,01/03/2003,P_301/03/2003
];
product:
LOAD * inline [
product,name
P_1,product_1,
P_2,product_2
P_3,product_3
P_4,product_4
];
date:
LOAD * inline [
date,month,year
01/01/2001,1,2001
15/01/2001,1,2001
31/01/2001,1,2001
01/02/2002,2,2002
01/03/2003,3,2003
];
Thanks in advance
You need to handle it in expression using if()
Calculated dimensions
=Aggr(If(date,date,' '), product,date)
=Aggr(If(tag,tag,' '), product,tag)
Hi @JMAROUF ,
Is it necessary to show the P4 in the table?
you can get rid of that row if you join the table in the script.
date:
LOAD * inline [
date,month,year
01/01/2001,1,2001
15/01/2001,1,2001
31/01/2001,1,2001
01/02/2002,2,2002
01/03/2003,3,2003
];
fact:
LOAD * inline [
product,tag,date,key
P_1,T_1,01/01/2001,P_101/01/2001
P_1,T_1,15/01/2001,P_115/01/2001
P_1,T_1,31/01/2001,P_131/01/2001
P_2,T_2,01/02/2002,P_201/02/2002
P_3,T_1,01/03/2003,P_301/03/2003
];
left join(fact)
product:
LOAD * inline [
product,name
P_1,product_1,
P_2,product_2
P_3,product_3
P_4,product_4
];
You need to handle it in expression using if()
Calculated dimensions
=Aggr(If(date,date,' '), product,date)
=Aggr(If(tag,tag,' '), product,tag)
Thank you @abhijitnalekar , I can't join the table.
Thaks @vinieme12 , It works just for date but not for tag.
Hola JMAROUF si no necesitas mostrar los valore nulos le puedes presionar
y listo se quitan los valores nulos.
Thanks @luiferva ,
I'm looking to show the value of dimension, I can'T hide it.