topic Join help in QlikView

Join help

pawwy1415 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 16 Apr 2018 11:00:13 GMT

Hi,

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

tresB — Mon, 16 Apr 2018 11:07:08 GMT

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

Table1

Join

Table2

keerthika — Mon, 16 Apr 2018 11:25:38 GMT

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