Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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';
Trans_MAF:
LOAD
'Activations' as CUSTO_ID,
YEAR(ACTIV_DATE) AS An_raportare,
MONTH(ACTIV_DATE) as Luna_raportare,
date(ACTIV_DATE) as Data_Raportare,
CONTR_ID,
[MAF final] as COMPUTED_MAF_SIM
FROM
$(TRANS_MAF_HISTORY)
(ooxml, embedded labels, table is Activations);
Thank you,
Cosmina