Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just start in QV . Now I have problem about QVD file.
I 'm not sure when i make qvd file in qvw .
i have to use " Where Exists(ItemCode,Item_No) " add in after Path (qvd) .
When i reload file. I don't get the data. \
Why I don't get data? and Where Exists( , ) don't use with QVD or not?
Thank a lot
I think that the where exists() part might not execute when the QVD is loaded in QVD optimized form.
Try adding a text() or num() function around a string field or numeric field in your QVD load to force QV to expand the QVD file on load and this should hopefully trigger your where exists() statement as well.
According to best practice it would be better to organize your process in two steps. The first step load your table from qvd (without any conditions). In this case qvd-optimizer will work and all data will be upload as soon as possible. ON the other step you have to select data according to your condition
When your are using exists function, you should keep in your mind and check that the first field (in your case ItemCode) has to exist in QV-memory and Item_No should present in your current Load function.
I don't think there should be any problem using "where exists()" with a QVD file. I'd focus on troubleshooting the exists() function itself - look at the two fields, compare their formats etc...
For example, it's common for Item Numbers to have numeric values stored in text fields. Sometimes this field can be loaded as a number in one type of load and as a text in another load. Verify that your fields are comparable.
As a side comment, if your QVD file is large, you actually WANT to keep the load as optimized. To do that, you need to use where exists() with a single field name - that means that both fields need to be called the same.
Oleg:
When using exists() fields do not need to be named the same.
You can always pass a second parameter if you want to compare different fields.
ie:
where exists (fieldX, fieldY)
Kind regards
BI Consultant
Magnus,
yes, I'm aware of both syntax forms. The difference is that when you load a QVD and using a single field format, the load remains optimized, and if you are assing the second parameter, the load becomes non-optimized and very slow.
If you ever loaded a large QVD with exists(), you'd notice the difference.
Oleg