Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vardhancse
Valued Contributor II

Excel latest sheet from a workbook

Hi,

I have got one requirement,

I have one excel work book with approx 15 sheets.

as part of initial load, have loaded all the excel sheet using OBBC connection.

Now the requirement is that from the next reload I need to load the recent sheet and append to the existing table.

can any one please let me know the options to achieve the same

4 Replies
vinieme12
Esteemed Contributor II

Re: Excel latest sheet from a workbook

do your sheet name's provide any clue as to which one is the most recent sheet? for example a number or date value??

vardhancse
Valued Contributor II

Re: Excel latest sheet from a workbook

Hi Yes, sheet names will be in the format of J'AN 2017 Breaks' & 'Feb 2017 Breaks'....

vinieme12
Esteemed Contributor II

Re: Excel latest sheet from a workbook

can you post some sample to work with?

prieper
Honored Contributor II

Re: Excel latest sheet from a workbook

you may refer to the excel-workbook with ODBC-connection.

SQLTABLES will give you the workbooks.

You may check the returned names and decide programmatically, which is the last one (IF WILDMATCH(Table, '*DEC*') THEN .....)

HTH Peter