Tables names are not consistent

[mohanrajsubrama]

Hi Guys,

How do I handle tables names if its not consistent.

For Ex:

New tables getting generated daily basis with some random Table Name.

How do I handle it in Qlikview.

If its same table name with different months Probably I can append it using variable like +1 to it to get the next month data.

Any ideas or suggestions are appreciated?

Regards,

Mohan...

[Siva_Sankar]

Mohanraj,

You can refer these documents Dynamically Loading Multiple Excel Files and Load all Excel files and all sheets in a folder or Load all tables in database dynamically

Siva

[mohanrajsubrama]

Siva ,

Thanks for the Quick response.

The above link helped. But I am trying to bring all the tables listed from particular schema in PostgreSQL .

And apply the script to append one by one .

SQL SELECT DISTINCT "TABLE_NAME"

FROM "INFORMATION_SCHEMA".COLUMNS; (This is for MS SQL Server database)

I am trying to get the same script work for PostgreSQL.I Even tried \dt to get all the tables list for PostgreSQL but it did not work.

Regards,

Mohan

[Siva_Sankar]

Hi Mohan,

The procedure is same, except that for PostgreSQL you need different syntax and you have to refer the link mentioned in the document Load all tables in database dynamically