Retrieve Table name

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Retrieve Table name

sunny_talwar — Fri, 06 Jan 2017 12:21:27 GMT

May be use

FileName()

FileBaseName()

File functions ‒ QlikView

topic Retrieve Table name in QlikView

Retrieve Table name

Re: Retrieve Table name