Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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?
Wrong forum.
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
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
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
can we do using loads?