Discussion board where members can get started with QlikView.
I am loading with * all the xls, like below. I have identified invalid data field and i want to identify the xls which cause the issue. Is there a way to add the name of the table loaded from script?
let TRANS_MAF_HISTORY='D:\Cosmina\3. Data Excel\MAF*.xlsx';
'Activations' as CUSTO_ID,
YEAR(ACTIV_DATE) AS An_raportare,
MONTH(ACTIV_DATE) as Luna_raportare,
date(ACTIV_DATE) as Data_Raportare,
[MAF final] as COMPUTED_MAF_SIM
(ooxml, embedded labels, table is Activations);
May be use
File functions ‒ QlikView
View solution in original post