Problem in combining two different scripts in single QVD load

[Anonymous]

Hello All,

I have an starnge issue when I am doing load.

I have two files and doing incremental load. It is working fine. If I combine those two files in single QVW file it is not ending. It is just creating QVD's and not closed . If I run individually it is working and closing properly.

Can you see the below screen shot.

Please can anybody help me on this issue

Let Vqvxpath = 'D:\QlikView\SourceDocuments\QVX\Mktg_Funnel_Prj\';

Let Vqvdpath = 'D:\QlikView\SourceDocuments\QVD\Mktg_Funnel_Prj\';

inserts:

LOAD *,AutoNumber(time_month_key&lead_id) as num FROM

$(Vqvxpath)source_lead_passed_eom_snapshot_insert.qvx (qvx);

If FileSize('$(Vqvdpath)Lead_Passed_EOM_Snapshot.qvd') > 0 then 

    LOAD * 

    FROM $(Vqvdpath)Lead_Passed_EOM_Snapshot.QVD(qvd) 

    WHERE NOT Exists(num,AutoNumber(lead_id&time_month_key)); 

    ENDIF;

DROP Field num;

STORE inserts into $(Vqvdpath)Lead_Passed_EOM_Snapshot.QVD(qvd);

DROP Table inserts;

////////////////////////////////////////////////////////////////

inserts:

LOAD *,AutoNumber(time_month_key&opportunity_id) as num FROM

$(Vqvxpath)source_opportunity_passed_eom_snapshot_inserts.qvx (qvx);

If FileSize('$(Vqvdpath)Opportunity_Passed_EOM_Snapshot.qvd') > 0 then 

    LOAD * 

    FROM $(Vqvdpath)Opportunity_Passed_EOM_Snapshot.QVD(qvd) 

    WHERE NOT Exists(num,AutoNumber(opportunity_id&time_month_key)); 

    ENDIF;

DROP Field num;

STORE inserts into $(Vqvdpath)Opportunity_Passed_EOM_Snapshot.QVD(qvd);

DROP Table inserts;  

[andrespa]

Hi Kumar,

It seems to me like a Synthetic key issue. You should have some fields that are the same in your tables and Qlikview is trying to resolve a really large Synthetic key.

Hope it helps.

Cheers,

Andrés

[Anonymous]

Thanks Andres,

I have two files. In each file I have different columns and also, I am not joining any where at all. I am trying to store these two different files into two different QVD's.

Regards,

Kumar

[Anonymous · Accepted solution]

Thanks all who are all spending time to give me a solution.

I resolved the issue.

[andrespa]

Great! And what was the problem??