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: 
Anonymous
Not applicable

Please help me out on this scenario

Hi guys,

I have scenario.I have attached image.please respond,thank you

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@adutta , you can create a cluster id based on below way.

 

0683p000009M8IA.png0683p000009M85m.png

View solution in original post

7 Replies
Anonymous
Not applicable
Author

Hi
I see you just need to add a new column 'cluster_id', I have a question about the column value, how is '1' calculated?

Regards
Shong

Anonymous
Not applicable
Author

Hi thanks for the reply.we need to give cluster id based on GID.

from my source i am getting company names like that so i need  to group that with TMATCHGROUP component so then i will get GID is same for matching companies.so in next step i need to assign cluster id based on GID.

manodwhb
Champion II
Champion II

@adutta , you can create a cluster id based on below way.

 

0683p000009M8IA.png0683p000009M85m.png

Anonymous
Not applicable
Author

Hi bro can you please send the code,what you written in variables in tmap.

manodwhb
Champion II
Champion II

@adutta , find the below variable

row2.GUID.equals(Var.var1)?Var.var2:1+Var.var2

Anonymous
Not applicable
Author

Thank you so much bro,got it

Anonymous
Not applicable
Author

bro small help

 

accent input      accent output
Àditya              Aditya
Áditya             Aditya
Âditya            Aditya
Ãditya           Aditya
Äditya           Aditya
how do i replace those symbols with "A"