You are not logged in.
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.
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)