1 of 1 people found this helpful
This can easily be done using a Union not a join. Only think you need to take care is that the column names are entirely distinct to get the distinct results.
Similar to the sample you mentioned. I created the following data.
These are currently in 2 different sheets of an excel.
After connecting to the excel, drag dropping both the sheets in the following manner.
The result would look like this.
Exactly how you would like with 2 additional columns that can be of help going further.
Hi Jeevan Krishna,
When i use union, i am getting data from one table and for second table data was show as "<invalid value>". union was not working properly.
What is your data source? Have you extracted your data? If no, can you try extracting your data and check?
I am using Mongodb data source. In mongodb collections we have "_id" column as mandatory in all the collection.