Data mapping without duplicates

Saiteja1 — Sat, 13 May 2023 04:01:19 GMT

we have two types of data sets one is source data and one is hierarchy data with market and business

source data contains :

market name

business name

aggregate

data1

data2

hierarchy data contains :

market key

market name

business key

business name

Now the output should not have any duplicates

for example let us consider a market

North America

In source data it has

Aggregate,Market name ,data1

Region,North america, 54

Sub Region,North america, 60

Zone,North america, 66

In hierarchy data it has

market name ,market key

North america , M_NAM

North america , M_NAMS

North america , M_NAMZ

Now I should need data with out duplicates while selecting market how should I join data

Can you please help me out with this

Thanks in advance

Re: Data mapping without duplicates

BrunPierre — Sat, 13 May 2023 14:16:05 GMT

Hi, @Saiteja1 what should be the output?