segmenting a large transaction table into multiple qvd files

[mstoler]

Hello,

I need to read in a large transaction file with about 200 million records for 3 years from SQL.

The users of this file will only need to read in parts but I do need the entire file.

I was thinking of segmenting this into 3 qvd files by year.  This would results in smaller files.

I was wondering if anyone has explored this approach to segment a large table into multiple qvd files.

In addition I would only need to update the current year file every day.

[rwunderlich · Accepted solution]

I have used this approach many times. See this post for some thoughts and techniques. 

https://qlikviewcookbook.com/2022/03/how-to-segment-qvd-files/

-Rob

[mstoler]

Thank You.

I appreciate your contributions to the community.

Michael