Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the table fact Venta with the foreing keys Local_Id,Producto_Financiero_id, Cuenta_Id, Tarjeta_Id, Cliente_Id,Subcanal_Id. And I want to join those foreing keys directly to the Primary keys of his tables, but the qlick Sense aplication create sintetic tables for join those keys throw them. There is a solution for make the direct join, the FK even have the same name for those join automatically. Thanks in advance
if the combination of many fields is the only right combination of links you have to create a combined field in both tables
eg
Producto &'-'&localId&'-'&subcanalId as Key
In one table let the single fields as select able values (eg only select one subcanal)
Regards