topic Wildcard in Table Name in QlikView

Wildcard in Table Name

Mon, 17 Sep 2012 02:20:47 GMT

Hi,

I have had a look around and couldnt find any answers to this question (and I have never used QV to pull from databases before) so sorry if this is already covered somewhere.

I am trying to pull call history data out of a contact centre dialling program. It saves the call history in a table for each day, so to look at a lot of history I need to upload many tables.

eg. table names are call_history010512 and call_history010612 etc. I have over a year of data, so I dont really want to go through and select them individually if I can avoid it.

is it possible to use a wildcard in a table name in order to upload the same fields from all tables?

eg. If I try "call_history*" it comes back saying that the specified table (call_history) is not in the database.

Thanks for any advice you can give me.

Re: Wildcard in Table Name

Mon, 17 Sep 2012 04:19:26 GMT

Hai Any one can explain what is this problem while doing qlikview 11 instalation

Re: Wildcard in Table Name

Mon, 17 Sep 2012 05:33:16 GMT

Hi,

My advice would be load the list of table which start with "call_history" (in oracle select * from all_tables where table_name like 'CALL_HISTORY%') into qlikview.

Run a loop in this table to into the master table. Sample code goes like this.

TableNames:
SQL SELECT TABLE_NAME as tables from ....;
For a = 0 to NoOfRows('TableNames')
vtableName = Peek('tables',$(a),'TableNames');
CallHistory:
SQL Select * from $(vtableName);
Next

Regards,

Kiran.

Re: Wildcard in Table Name

Mon, 17 Sep 2012 23:25:24 GMT

Thanks Kiran, That suggestion worked perfectly. I appreciate you taking the time to help out.