topic Re: Tables names are not consistent in QlikView

Tables names are not consistent

mohanrajsubrama — Wed, 10 May 2017 19:29:44 GMT

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...

Re: Tables names are not consistent

Siva_Sankar — Thu, 11 May 2017 01:44:12 GMT

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

Re: Tables names are not consistent

mohanrajsubrama — Thu, 11 May 2017 23:36:33 GMT

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

Re: Tables names are not consistent

Siva_Sankar — Fri, 12 May 2017 01:51:03 GMT

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