Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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