Sirs, I have the simple need to translate some columns from a table with 7 columns to a table with 3 columns using the rule below... SELECT CONCAT(DATE(date),' ',HOUR(date),':00:00'), COUNT(transaction), operstatus_ID FROM transactiontable GROUP BY DATE(date), HOUR(date), operstatus_ID ORDER BY DATE(date), HOUR(date), operstatus_ID But I couldn`t do it with success until now... Putting this query in the properties of the component tMySQLInput, I receive that: schema is different from query. The 'Guess Schema' button doesn`t work. Someone can help me in the creation of my schema? Lot of thanks.