Hi,
I'm looking to see if I can retrieve all tables with the same prefix and then save the table content with a dynamic writer in shape format.
For this I start with a SQLCreator with the query:
select TABLE_NAME GV_TABLE
from cols
where TABLE_NAME like 'AB$_%' escape '$'
and TABLE_NAME in
(
select object_name from user_objects where object_type = 'TABLE'
)
The result is then picked up in a SQLExecutor:
select *
from @Value(GV_TABLE)
Attributes to Expose is left empty in the SQLExecuter.
The result of the SQLExecuter looks like empty records but if you look with Visual Preview the attributes per table are present. With a dynamic writer I try to write to a shape file per table. The writer does not write anything.
So is it possible to make the attributes visible after the SQLexecuter? Attributeexposer does not have a *.* wildcard.
