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: 
Riya_juneja
Contributor II
Contributor II

error in the Store statement

I am facing an error in the Store statement 

This is  my script.This is my script.Screenshot (17).png

Labels (2)
1 Solution

Accepted Solutions
Iswarya_
Creator
Creator

@Riya_juneja , If the issue is solved please mark the answer with Accept as Solution

View solution in original post

5 Replies
Chanty4u
MVP
MVP

Hi,

is issue with only this table or any other store?   and try loading only that excel to store .

itseems above tables loaded .    can you with out variable and check is it loading or not?

 

or else try this

set QvdPath = 'lib://$(DataHome)/Other_path';

 

STORE TableName  INTO '$(QvdPath)\TableName.qvd'  (qvd);

Iswarya_
Creator
Creator

Hi,

I think table "Employee2" gets auto concatenated with some other previously loaded table. The reason for this behavior is there is a similar or equal column list of both tables. So you have only one table in the end.

You can prevent this by using NOCONCATENATE LOAD before table "Employee2".

Riya_juneja
Contributor II
Contributor II
Author

Yeah!! I also think so.

Thanks for the answer.

Riya_juneja
Contributor II
Contributor II
Author

Thanks for reply.

Iswarya_
Creator
Creator

@Riya_juneja , If the issue is solved please mark the answer with Accept as Solution