topic Reading Tables Dinamically in QlikView

Reading Tables Dinamically

christian77 — Tue, 06 Sep 2011 07:25:25 GMT

I’m working in a SQL data base. They are some tables in that data base named Cuestionario1, Cuestionario2, Cuestionario3, …, CuestionarioN. I need to upload them all, but I don´t know how to do it dynamically.

In other words, how can I retrieve the number of Cuestionarios before, in order to reload them.

Thank you all.

Reading Tables Dinamically

christian77 — Tue, 06 Sep 2011 07:43:37 GMT

I meant Dynamically.

Reading Tables Dinamically

Tue, 06 Sep 2011 07:59:07 GMT

Hi,

If you know how many tables are there, i mean N you can lopp through using for and next to load the tables.

Can you please elaborate the actual requirement.

Cheers.

Reading Tables Dinamically

christian77 — Tue, 06 Sep 2011 08:03:04 GMT

That's what I want to know, how many tables they are with that name. Then I'll loop.

Reading Tables Dinamically

Tue, 06 Sep 2011 08:23:20 GMT

Hi,

First you can load all the table names starting with 'Cuestionari' using the below query.

SELECT * FROM sys.Tables where name like ('Cuestionari%')

Then loop through the Name field from the above load and fetch all the tables.

Cheers.