Joining two cross tables and avoid duplicate entries

[#1]

Hi,

I have 2 excel sheets sample data(Attached File).Difference between Sample Data 1 and Sample Data 2 is the column value Segment Id.

id.

Segment Id 's are mapped to different Segment Names .Eg : Segment Id  a) 0 - popu .

                                                                                                            b) 1- The trat

I have to use a cross table as per the requirement and its working fine.

I want the data to be displayed in the pivot table as per the screenshot (Attachment - Screenshot).

Issue here is :

After cross-table of the excel sheets in the script,the value is populating in the script along with the duplicate entries.The duplicate entries are a result of column Segment Id in the excel sheets(Sample 1 and Sample 2)

Can anyone suggest me how to avoid the duplicate entries?

[divianjani]

Hi Harshitha,
Use DISTINCT and Try so that duplicate records will not show.

[#3]

Thank u.

I had to add a calculated dimension for segment name and select the checkbox for Suppress wen value is null.

If(Segment Name = 'a' or Segment Name = 'b' ,Segment Name)

[divianjani]

Hi Harshitha,

Please find below attachment, I hope this helps you and  in this attachment not showing any duplicate records.
check it once:)

[#5]

I mean to say I got the solution and the solution is the above calculated dimension

[#6]

I cant find any attachment as well

[divianjani]

ok good carry on:)