Union of different table in different odbc sources
Hi,
i am creating a single table from different odbc sources with same structure (result of the join of other tables) , if i put the odbc connetion statements, without any join or concatenate ,only putting on the trot in the script this solution seems to create a table contained the different odbc connection tables.
please is it really correct, or it need some statement to have a real table?
When the tables you read (in your case from different odbc connection) have the same number and same names of fields QlikView concatenates the tables, so you only get one table in QlikView db. QlikView concatenate is similar to sql union (union all).
