Home
Developing Analytics Applications
How to remove the duplicates from Data Set / Union / Table?
Migrateduser
<p>Hi Team,</p>
<p> </p>
<p>Good Day....!!!</p>
<p> </p>
<p>I have a specific case to remove(not hide) the data from the Data set / Union / Table in my iHub report. Can anyone suggest how to implement this? </p>
<p> </p>
<p>Business case:</p>
<ul><li>I have 3 Data sets, from which i have created 2 joins</li>
<li>in one of the join i have duplicate values (not because of the join condition)</li>
<li>Union created by using 2 joins. Union returns with both joins with duplicate values. Here Union is behaving like Union All. As per the product behaviors Union will return Union ALL.</li>
</ul><p>So is there any way to remove the duplicates from Data Set / Join / Union / Table level?</p>
<p> </p>
<p> </p>
<p>Thanks,</p>
<p>- Ravi </p>
Find more posts tagged with
Comments
There are no comments yet