Multiple fact tables

[#1]

I have a script which includes the following:

TABLEA:

LOAD  ''AP' as RecordType, A, B, C

Select A, B, C from SQLTABLEAP

CONCATENATE LOAD  ''AD' as RecordType, A, B, C

Select A, B, C from SQLTABLEAD

TABLEB:

LOAD A, B, C, D, F

SQL exec QLIKVIEW_SP

Now when i look at the table view of the scipt, TABLEB has a link to TABLEA as there are fields which are common.  However, I do not want this link to the TABLEA fact table as it is causing the results to be returned which i dont want. 

Also, in the script I have dim tables for which TABLEA and TABLEB link which is what i do need so that is fine.

Please advise.

[Anonymous]

Use Left join instead of Left Keep. It works same, keep will not merge the tables in one where as join merge the tables in one.

[#3]

that seems to still cause an  error on the table name. 

[Anonymous]

Can you attach a sample file with those tables to analyse better?

[#5]

sure - how can attach a sample file here. 

[Anonymous]

Use advanced editor (top right corner,you can see while replying) for attaching any file.

[#7]

see example attachment.

[Anonymous]

Find attached. Hope it helps.