topic Excel latest sheet from a workbook in QlikView

Excel latest sheet from a workbook

vardhancse — Tue, 13 Jun 2017 10:48:13 GMT

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

vinieme12 — Tue, 13 Jun 2017 13:03:12 GMT

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 — Wed, 14 Jun 2017 02:37:47 GMT

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

vinieme12 — Wed, 14 Jun 2017 07:15:54 GMT

can you post some sample to work with?

prieper — Wed, 14 Jun 2017 11:30:13 GMT

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