Discussion Board for collaboration regarding Qlik DataMarket.
I have two tables A and B. A has Customer Group while B has Customer Group Name.
I have customers of A only appear in my pivot table.
Since I need data from B table also but corresponding to only customers of A.
How to match customers of A and B ?
I am using
if ([Customer Group]=CUSTOMER_GROUP_NAME , [Customer Group])
But this gives only customers in Abbreviation like BCGH but not be able to map like 2degrees.
Go to Solution.
I'm talking something like this:
// Assuming TableB has been loaded
Mapping Load CUSTOMER_GROUP_NAME,OtherField
ApplyMap('MappingTableB', Upper([Customer Group])) as OtherFieldfromTableB
Is there anything in common between the two tables?
Can you please share some screenshots of the data? or the data model?
If you're asking about ApplyMap, you still need values that are similar but the mapping tables needs to be prepared
But I have to do mapping between two tables by keeping common Customer Group of table A and map also Customer Group of table A.
i.e. common and mapping column is same.
Ok, please show me data so I can see what I can do...
Customer Group is the column in A and Customer Group Name in B.
I want to map Customer Group from table A into table B.
But these names like 2company ,Flying do not map whereas only A&P map.
Ok, a Mapping Load with Uppercase should work fine.
What field do you want to bring from TableB into TableA?
1:If in the script use Applymap() depending on your data structure.
2: In the UI use UPPER([Customer Group]) as your column .
3: May be try using mixmatch() for case insensitive comparision instead of IF.
Sorry for replying so late but Thanks a lot