load a list of table

martapardo — Sat, 16 Nov 2024 20:58:10 GMT

Hi, I am using Qlick Cloud. I need to create a table which is made by a concatenation of tables, I am doing a for loop, my problem is that i think the FROM is not properly :

I get the following error:

The following error occurred:

Field 'Curso' not found

set vRoot = 'lib://AttachedFiles';

FOR Each Ext in 'xlsx'
FOR Each File in filelist ('$(vRoot)'&'/get_user_course_report_*.'&Ext)
LOAD
subfield(Curso,' ',1) as curso_nombre,
subfield(Curso,' ',2) as itinerario,
Curso,
Usuario,
"Correo electrónico",
Horas,
"Generó certificado",
Aprobado,
"Avance en el curso",
etl_uid,
Puesto,
Empresa,
"Fecha alta",
"Nivel interno",
DNI,
etl_aparcamiento_lector_matricula,
etl_aparcamiento_sistema_control,
etl_aparcamiento_pame,
etl_aparcamiento_nombre,
Responsable,
Responsable_email,
Fecha_Baja,
Fecha_exportacion
FROM '$(File)';
next File
next Ext

Re: load a list of table

Anil_Babu_Samineni — Mon, 29 Apr 2019 12:55:26 GMT

try to add only one field which facing error?

Re: load a list of table

martapardo — Tue, 30 Apr 2019 07:23:08 GMT

The problem is that I dont know how to set the path since it does not reconize [$(File)] as the path, and I try many different ways to do that and it doesnt work....

topic Re: load a list of table in App Development

load a list of table

Re: load a list of table

Re: load a list of table