Всем привет , есть код вида , но такое чувство будто MAPPING LOAD внутри цикла не обновляется, так как везде одни те же наименования
FOR each i in '1.1','1.1.1','1.2','1.3','1.4','1.5','1.6', '2.1','2.2','2.3','2.4','2.5','2.6','2.7', '3.1','3.2','3.3','3.4','3.5','3.6'
LIB CONNECT TO 'sbor in DWH (qlik)';
Qualify *;
Unqualify document;
Trace $(i);
Mapping LOAD num,
full_name;
[l_columns]:
SELECT num,full_name
FROM public.l_columns where "section" = '$(i)';
Mapping LOAD num,
name;
[l_rows]:
SELECT "num",
"name"
FROM "public"."l_rows" where "section" = '$(i)';
LOAD document,
row as row_num,
ApplyMap('l_rows',row,'???') as row,
ApplyMap('l_columns',col,'???') as col,
col as col_num,
value;
t_data_$(i):
SELECT "document",
"row",
"col",
"value"
FROM "public"."t_data" where "section" = '$(i)';
NEXT i;