Hi!
I'm getting this error when loading two tables of the same database:
Qvx file read error on line 1, too many columns: [tblDotacaoSemItem]: SELECT "Cd_Dotacao_Id", "Sigla_Orgao" FROM "sf8416_financas".dbo.tblDotacaoSemItem
The load script is quite simple:
LIB CONNECT TO 'SQL03';
LOAD Cd_Dotacao_Id;
[tblDotacaoComItem]:
SELECT "Cd_Dotacao_Id"
FROM "sf8416_financas".dbo.tblDotacaoComItem;
LOAD Cd_Dotacao_Id,
Sigla_Orgao;
[tblDotacaoSemItem]:
SELECT "Cd_Dotacao_Id",
"Sigla_Orgao"
FROM "sf8416_financas".dbo.tblDotacaoSemItem;
If I only load one table, the script runs fine, but whenever I join any two tables, I get this error.
The other posts on the forum say that it might be a DB performance issue, but the DB is ok, I can run the queries outside Qlik Sense, and the error also happens in debug mode with row limitation.
Thanks!