Retrieve Table name

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be use

FileName()

or

FileBaseName()

File functions ‒ QlikView