Conditional load from qvd

[#1]

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

[#2]

That is the full path, see attatchment.

I'am working in the QVDmaker.qvw

[#3]

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.

[ashfaq_haseeb]

Hi your code field is empty.

Regards

ASHFAQ

Otherwise my solution must work.

Regards

ASHFAQ

[aveeeeeee7en]

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:

[#6]

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!

[aveeeeeee7en]

The Code field doesn't contain any Data

[jvishnuram]

Hi, Your code field is empty.

[aveeeeeee7en]

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';

[PradeepReddy]

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';