I have the following problem: I want to import a lot of variables (~600) from an outer file. With the code below I was able to import them, but for a large group of variables the "Definition" section did not fill up. Tough I think their value (the expressions) are there, because when I hover over the name of the variable, the expression pops up, but just for a second. Could you help me? My I aim is to be able to fill up all the definitions.
VariableDescription2: LOAD Name, RawValue FROM [URL of text file\Variables.txt] (txt, utf8, embedded labels, delimiter is ',', msq);
// Create variables for i = 0 to NoOfRows('VariableDescription2') - 1
let vName = peek('Name', i, 'VariableDescription2'); // Name of the variable let $(vName) = peek('RawValue', i, 'VariableDescription2');
Have you tried to load few columns to test whether it works?
I am guessing maybe QV can't load some specific character in some columns like below specified.
Character set problems with non-ANSI encoded data files
You may experience problems with character encoding in non-ANSI encoded data files when using an ODBC data connection.
ODBC data connections do not provide full capabilities for character set encoding.
Do the following:
If possible, import the data files using a folder data connection, which supports more options for handling character codes. This is probably the best option if you are loading a Microsoft Excel spreadsheet or a text data file.
first of all thanks for the comments. What really interesting is, that when I am loading the variables into an empty application, all of them gets their definition properly. Though when I try to do the same with an application that already has script/data then a great deal of these variable definitions are empty. So I guess it is not the question of formatting, otherwise it would not work in an empty application.
My main object is to use Git with QlikView. What gets problematic though is the handling of variables, where the definitions are handled as data, therefore not taken into consideration by Git. In order to be able to use these definitions, I am storing the variables into a txt file. After recreating the application from the files on GitHub/Gitlib, I am reloading the variables from the txt at the end of the script.
The big problem is, it is not loaded properly when the application itself is not empty.
I managed to get in the variables (most of them) by deleting the previous ones from the GUI Varlable Overview tab. But when I try to reload them via txt or csv, there are a number of variables that are not loaded into the app at all (not even the name). I've looked into them but they contain the same characters/values as variables that have been properly loaded.Any ideas? What am I doing wrong?