Join help

[pawwy1415]

Hi Experts,

Can any one please help me on below requirement,

In my oracle query i have Cross join

In qlik which join need to use for replication above Cross join logic.

Thanks in advance.

[niclaz79]

Hi,

I believe an inner join would create the cross join result for Qlik.

[tresesco · Accepted solution]

Default join in qlik is cross join. For that, you can leave join alone, like:

Table1

Join

Table2

[keerthika]

Hi kumar,

If two tables doesn't have any common columns you can just load that two tables or use join between them both performs cross join.

Load VLK_DESK_SCOPE_VW;

load VLK_RISK_FACTOR_MVW;

Load VLK_DESK_SCOPE_VW;

join (VLK_DESK_SCOPE_VW)

load VLK_RISK_FACTOR_MVW;

Both gives same result

Thanks,

Keerthika