Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
cocosmina
Contributor II

Retrieve Table name

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Retrieve Table name

May be use

FileName()

or

FileBaseName()

File functions ‒ QlikView

View solution in original post

1 Reply
Highlighted

Re: Retrieve Table name

May be use

FileName()

or

FileBaseName()

File functions ‒ QlikView

View solution in original post