Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Wildcard in Table Name

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. 

1 Solution

Accepted Solutions
Not applicable

Re: Wildcard in Table Name

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.

3 Replies
Not applicable

Re: Wildcard in Table Name

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

1.bmp

Not applicable

Re: Wildcard in Table Name

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.

Not applicable

Re: Wildcard in Table Name

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

Community Browser