topic Re: Load data from Dynamic DB Tables in QlikView

Load data from Dynamic DB Tables

Prabhu1204 — Tue, 23 Feb 2021 06:54:06 GMT

Hello

I have a table" Department" and the table name would be dbo.department, 3 months once or 4 months once DB team will be creating a table Department_Date. so how we can automatically pull the table. without manually adding the tables each time

Re: Load data from Dynamic DB Tables

Prabhu1204 — Tue, 23 Feb 2021 08:47:56 GMT

@MayilVahanan Can you provide me some ideas

Re: Load data from Dynamic DB Tables

MayilVahanan — Tue, 23 Feb 2021 09:09:02 GMT

Hi @Prabhu1204

Might be, you can add the table names in the excel sheet & load it dynamically.

so that, no need to edit the table.

or, you can follow this link

https://community.qlik.com/t5/QlikView-Documents/Load-all-tables-in-database-dynamically/ta-p/1496496