Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martapardo
Contributor
Contributor

load a list of table

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

Labels (1)
2 Replies
Anil_Babu_Samineni

try to add only one field which facing error?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
martapardo
Contributor
Contributor
Author

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....