Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Loading multiple transaction files using from c:/filename*.txt.
filename have a suffix depending on company within a large organization.
The problem occur when I want to ApplyMap, only the last filename gets mapped.
How to handle this issue?
rgds thomas
That is then a completely different question! It is possible to get a list of tabs within an Excel spreadsheet by connecting to it with an ODBC connection (a native QlikView connection will not work) and issuing a SQLTables statement. I suspect there will be information on this somewhere in the community.
What I have done in the past (to give more control over which tabs are loaded and what should be expected on each tab) is to have a sheet in the excel spreadsheet with a known tab (eg. Tab List). This can list the names of all the tabs in the spreadsheet - and give extra info if required. The load script can then load the list of tabs and enumerate around it (using a For vTab = 0 to NoOfRows('Table') - 1 loop) and read each tab name to a variable (using Peek) and then use the variable in the load.
Hope that helps.
Steve