topic Re: how to show data from a particular table in QlikView

how to show data from a particular table

Tue, 01 Dec 2015 09:59:25 GMT

Hi ,

I have loaded data from around 20 tables with same headings but different data. I would like to show data from a particular table in table box. If I am trying to do so, table box is showing data from all the tables as the headers are same in all the tables. Could you please suggest me ..how can I show data from a particular table.

Thank you,

Kishore

Re: how to show data from a particular table

eduardo_sommer — Tue, 01 Dec 2015 16:23:12 GMT

Hi,

Try creating an extra column in the load, with the name of the source.

Load 'Table1' as TableName,

...

After this, you can filter which source table to display data, from

Regards

Eduardo

Re: how to show data from a particular table

anlonghi2 — Tue, 01 Dec 2015 16:28:16 GMT

Hi Kishore,

you can add a new field to your table to store the origin table.

Eg:

LOAD FIELD1,

FIELD2,

tagtoidentifydatasource as DATASOURCENAME,

...

In the above example tagtoidentifydatasource could be the name of the data source, the index of your for...next loop, etc. etc. depending on how you load your 20 tables.

Best regards

Andrea

Re: how to show data from a particular table

settu_periasamy — Tue, 01 Dec 2015 16:32:26 GMT

Hi Kishore,

is that concatenated with a single table or different table joined with Key?

you can check it from TableViewer(hope you know this)

if the tables are separated, then you can check Table Box properties -> Show Fields From Table -> it will show all the table.

Re: how to show data from a particular table

Tue, 01 Dec 2015 17:08:57 GMT

Thank you ...

Re: how to show data from a particular table

anlonghi2 — Tue, 01 Dec 2015 18:21:26 GMT

you are welcome

Best Regards

Andrea