I am writing a custom query (query in metadata folder) and i want to include the query field names (select xyz as abc from def) in the delimited file output.  I turned off the header because it was populating the field names of the table in a schema. 

Update....
I am trying to get some counts, number of nulls, max and mins etc from each table using the custom sql but the summary data (counts etc) is not in a table.  Which might explain why the schema field values are getting appended into the excel output.  It seems like I have to either create a table on the database with the information and create a schema of that or bring all the data to my workstation from the db into a file and do the counts, number of nulls etc?


Any advice is greatly greatly appreciated.

Still trying to resolve this.  Not fun.

Here is my screenflow.  The error I am getting is cannot convert big decimal to int.  I have tried using to_char in the schema query, tried t_map to change the data type.  All i want is a flat file output with three columns that represent count(*), max, min for each table.

So I would iterate through each table and capture the counts, max, min and I need the tablename as a column in the output.  Seems simple but not!

the error message is cannot convert big decimal to string in Tmap.

Last edited by sheridany (2009-09-04 02:47:25)