topic Conditional load from qvd in QlikView

Conditional load from qvd

Wed, 23 Jul 2014 09:34:31 GMT

I have saved al my tables from my database in gvd files.

Also a joined table.

Now I want to link that joined table with two tables (with data from the joined table)

one where the code starts with a P and one where the code starts with an A

I added the script.

dot_action is my joined table, the selected fields are from the joined table.

How do I write the conditional load statement?

Because how I did it is not working.

Kind regards,

Katleen

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 09:42:43 GMT

Try this:

LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='P';

Concatenate

A_actie:
LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='A';

Re: Conditional load from qvd

Wed, 23 Jul 2014 09:47:24 GMT

Doesn't work, I get the error: script failed.

Any other ideas?

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 09:48:58 GMT

Use Concatenate inbetween them:

P_actie:

LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='P';

Concatenate

A_actie:
LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='A';

Re: Conditional load from qvd

ashfaq_haseeb — Wed, 23 Jul 2014 09:53:01 GMT

Hi,

Try below

P_actie:

LOAD id,

product_id,

dotation_id,

status

FROM

QVD\dot_actie.qvd where status like 'P*'

(qvd);

A_actie:

LOAD id,

product_id,

dotation_id,

status

FROM

QVD\dot_actie.qvd where status like 'A*'

(qvd);

Regards

ASHFAQ

Re: Conditional load from qvd

Wed, 23 Jul 2014 09:53:29 GMT

Still the same error and I don't want to concatenate them, I need those in two seperate tables

Re: Conditional load from qvd

Wed, 23 Jul 2014 10:00:06 GMT

Doesn't work either, still the same error.

Re: Conditional load from qvd

SunilChauhan — Wed, 23 Jul 2014 10:04:48 GMT

LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='P';

A_actie:
LOAD id,
     product_id as A_actie_product_id ,
     dotation_id as A_actie_dotation_id ,
     status as A_actie_Status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='A';

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 10:04:56 GMT

Kindly check the path you are using is right or not.

Kindly rename the Table names since same names in both tables caused Synthetic keys

P_actie:

LOAD id,
     product_id,
     dotation_id,
     status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='P';

A_actie:
LOAD id,
     product_id AS A_product_id,
     dotation_id AS A_dotation_id,
     status AS A_status
FROM
QVD\dot_actie.qvd(qvd) where Left(status,1)='A';

Kindly give the full folder path where your qvd is lying.

Kindly change it:

FROM

QVD\dot_actie.qvd(qvd)

Re: Conditional load from qvd

ashfaq_haseeb — Wed, 23 Jul 2014 10:07:25 GMT

Hi,

Attach your qvd's

Regards

ASHFAQ

Re: Re: Conditional load from qvd

Wed, 23 Jul 2014 10:08:19 GMT

That is the full path, see attatchment.

I'am working in the QVDmaker.qvw

Re: Re: Conditional load from qvd

Wed, 23 Jul 2014 10:11:37 GMT

I have attatched a qvw file with my current script

and the qvd file with my joined table

the used field is 'code' (correct in this current script)

I mistyped in my first question.

Re: Conditional load from qvd

ashfaq_haseeb — Wed, 23 Jul 2014 10:15:48 GMT

Hi your code field is empty.

Regards

ASHFAQ

Otherwise my solution must work.

Regards

ASHFAQ

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 10:17:50 GMT

Your path should be like this:

DriveName eg. E: or 😧 which you are using\CiWeb\Apps\2.Extraction to QVD layer\QVD\dot_actie.qvd(qvd)

Go to Edit Script and Kindly uncheck the Relative Path:

Re: Re: Conditional load from qvd

Wed, 23 Jul 2014 10:20:30 GMT

It seems a lot of data has gone missing when I joined two tables in the dot_actie..

I'll try and fix and and then try your solution!

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 10:21:17 GMT

The Code field doesn't contain any Data

Re: Conditional load from qvd

jvishnuram — Wed, 23 Jul 2014 10:22:05 GMT

Hi, Your code field is empty.

Re: Conditional load from qvd

aveeeeeee7en — Wed, 23 Jul 2014 10:23:59 GMT

When you'll get data try with below script and replace Code with Status used in Where Condition.

I have Run this on my system, it is working fine.

LOAD id,

     product_id,
     dotation_id,
     status ,
     code
     FROM

(qvd) where Upper(Left(status,1))='P';

Re: Conditional load from qvd

PradeepReddy — Wed, 23 Jul 2014 10:39:33 GMT

P_actie:

LOAD id,

product_id,

dotation_id,

status

FROM

dot_actie.qvd(qvd) where UPPER(left(status,1))= 'P' or left(status,1)='p';

Concatenate

A_actie:

LOAD id,

product_id,

dotation_id,

status

FROM

dot_actie.qvd(qvd) where UPPER(left(status,1))= 'A' or left(status,1)='a';