Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That is the full path, see attatchment.
I'am working in the QVDmaker.qvw
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.
Hi your code field is empty.
Regards
ASHFAQ
Otherwise my solution must work.
Regards
ASHFAQ
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:
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!
The Code field doesn't contain any Data
Hi, Your code field is empty.
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
(
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';