Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Saiteja1
Contributor III
Contributor III

Data mapping without duplicates

Hi

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 

 

 

Labels (1)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Hi, @Saiteja1 what should be the output?