Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
Thank you ...
you are welcome
Best Regards
Andrea