topic Re: Problem in combining two different scripts in single QVD load in QlikView

Problem in combining two different scripts in single QVD load

Anonymous — Wed, 20 Jan 2016 09:47:11 GMT

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;

Re: Problem in combining two different scripts in single QVD load

andrespa — Wed, 20 Jan 2016 10:04:05 GMT

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

Re: Problem in combining two different scripts in single QVD load

Anonymous — Wed, 20 Jan 2016 10:08:26 GMT

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

Re: Problem in combining two different scripts in single QVD load

Anonymous — Wed, 20 Jan 2016 10:37:20 GMT

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

I resolved the issue.

Re: Problem in combining two different scripts in single QVD load

andrespa — Wed, 20 Jan 2016 10:43:02 GMT

Great! And what was the problem??