There are certain times where we require multiple columns in a single column. For eg there is a Plan Name and Plan Type where the client doesn't want to drill down to the next level but wants to see the Totoal Amount of all the Plan Name and Type together. For this we can use this method from the Analytics itself to bring about the changes.
In the below example First I am going to pull Year and Amount and then Plan Name and Amount for better understanding. Here I want to merge the Year and Plan Name in a single column
1.First Open and Analysis and pull in the Year and Amount
2. Now go to the Advanced Tab and copy the SQL
3. Do not close this analysis and Open a new analysis and pull in the Plan Name and Amount column. Go to the advanced tab and click on New Analysis as shown below.
4. Now paste the earlier SQL and bring about modification. Basically what we are doing here is that we are applying a union in the two SQL so that it can be visible in a single column.
Edit the SQL as mentioned below.
Click on OK and then you can see the YEAR and PLAN NAME column in a single column
Using this method we can merge 2 or more columns into a single column.
Try this out and if you have any doubts do get back.
Labels: Multiple Columns in a single column.