Hello Qlikies, I have a fields like below

[vvijaymanju1504]

Country, Sale
USA, 500
Canada, 1000
Canada Others, 200

I need to add Canada and Canada Others into a single field

Questions:-
1. using which load we have to add Canada & Canada Others into a single field in the back end?
2. should we use Pick & match in backend if it is yes, please let me know, how to do?
3. In front end should we do use set analysis and pick and match 


This is another question: - what is calculation dimension?


Thank you

[john_wang]

Hello @vvijaymanju1504 ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'm guessing I did not understand the issue very well. Would you please confirm the product name is Qlik Replicate? BTW, looks to me you trying to merge the 2 fields in Full Load stage (rather than CDC). Is that correct?

thanks,

John.

[vvijaymanju1504]

I want to merge canada and canada others into single field, should we do do using loads, if yes how to do and as well as how todo in front end also?

[Heinvandenheuvel]

Wrong forum. 

[SachinB]

Hello @vvijaymanju1504 ,

Are you trying to achieve using the Qlik Replicate? If yes, then we can try the below option for concatenation.

You need to define extra column and name it as per the need and using the function module you can concatenate the two values from different column. (As shown below)

Regards,
Sachin B

[SushilKumar]

hello @vvijaymanju1504 

The requirement in not logically correct as whenever any DML performed on the tables Colum it must have unique and before image also match if it going to perform and update and delete.

replication tools mainly work columns to columns basis. would suggest replicate the data as it as and by using the SQL query to represent or fetch data in desired manner as its much earlier doing at Sql level. 

Regards,

Sushil Kumar

[MayilVahanan]

Hi

Try like below

Country, Sale
USA, 500
Canada, 1000
Canada Others, 200

Load Country, Sale, 

if(Country = 'Canada Others', 'Canada', Country) as CountryMap

from yoursource;

User CountryMap in the front end. 

For, Calculated dimension , refer this link

calculated dimension - Qlik Community - 510104

[vvijaymanju1504]

can we do using loads?