Avoiding duplicate entries

[NavinReddy]

Dear experts,

Good Afternoon

if can i get updated data for current month same fact id its creating for multiple entries

how to avoid this issue on script i have many fact-ids having same problem

i want to make it below format

any suggestion please not sure how to resolve this issue

Best Regards,

Niranjan

[NavinReddy]

Hi Mindaugas,

Thank you so much for your support

exactly same but with this i want to select only Mar 16 Tier1 and Tier3

its helpful for me to develop application

Many Thanks,

Niranjan

[MindaugasBacius]

I am not sure if I do understand you correctly but if you just choose from the list you will get only March:

Or do you need to get rid of all the data except March in loading stage?

[NavinReddy]

yes exactly i need to get only march 16 tier1 and tier3

[MindaugasBacius]

Take a look.

[NavinReddy]

Hi Mindausgas,

Thanks again, im looking like the below format

Thanks,

Niranjan

[MindaugasBacius]

In your original table the fields Tier3 and Tier1 values differ so there is no way to make such table.

In case you have to change all the values in Tier3 to 3313 and Tier1 to 3397.

[NavinReddy]

Fine we can change tier values Tier3 to 3313 and Tier1 to 3397.

if we can make like that table

[#9]

If you are looking for that entries correct data set you should definitely use Cross-table statement.

In the prefixes zone and labels as embedded labels and https://goo.gl/fJU04B