Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
amaaiia
Contributor III
Contributor III

Store outer join table into QVD file

Hi!

I'm trying to store my table1 table into a QVD file, this table1 is created by the outer join of two sources.  I store one source data into table1, then I print the number of rows, and finally, I do de outer join with another source, and I print again the number of rows:

amaaiia_0-1698738349723.png

amaaiia_1-1698738536024.png

So, after the outer join, table1 has 135809 rows. But when I check the QVD file, it's empty.

If I write into QVD just the first data source (before doing the outer join), the data is written into QVD file, but not after joining.

How is this possible?

Labels (1)
1 Solution

Accepted Solutions
amaaiia
Contributor III
Contributor III
Author

I've reached the problem. It was about Disk Space, I didn't have enough so the data wasn't written into QVD file. However,  I don't know why a message error is not send..

View solution in original post

2 Replies
Mark_Little
Luminary
Luminary

Can you share a little more of the Script?

Share any other message you get on loading. Have you ran on debug? see if the file is getting written out when you expect?

amaaiia
Contributor III
Contributor III
Author

I've reached the problem. It was about Disk Space, I didn't have enough so the data wasn't written into QVD file. However,  I don't know why a message error is not send..