Creating QVD

[Motorsport28]

Hi guys

Im hoping someone can help. Im trying to create a QVD from a table which i have given the name Ëmployees but keep getting the error that employees cannot be found? 

[thi_pham]

Your load statement miss of specified data source. 

Such as:

Load fields Resident tablename.

Or

Load fields;

Sql select ...

[Motorsport28]

Hi TI

So i have the SQL Statement i have attached a complete screenshot

[thi_pham · Accepted solution]

The sql statement should be located right after load, like: 

Load fields;

Sql select fields from datatable;

[Motorsport28]

Thanks for you help!

I placed the script beneath the sql select statement and it worked! Much appreciated

[marksouzacosta]

Hi,

We just released a new video in our YouTube channel that may help others looking for some extra info on how to create QVDs. I hope it helps!

IPC Global Tips #6 - Creating QVDs - Regular and Incremental Loads
https://youtu.be/S9L6vWItchs

Regards,

Mark Costa