how to show data from a particular table

[#1]

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

[eduardo_sommer]

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

[anlonghi2]

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

[settu_periasamy]

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.

[#5]

Thank you ...

[anlonghi2]

you are welcome

Best Regards

Andrea