This content has been marked as final. Show 2 replies
When you are using union clause in analysis or combining with other subject area you suppose to have same number of columns and their datatypes with other analysis.
for datatype issues you can use cast in column expression in each analysis. If you want to add a column only from 1 analysis just add and in other analysis use dummy column with exp 0 or ''(for char) based on the datatype.
These you have to deal with each analysis.
If helps pls mark
mayby I figured out...
I tried to cut the second query, add the new column in my first, then paste again the second in the panel of combined areas.
Is this the correct procedure?