Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
krengan21
Creator
Creator

How to find and replace inside tmap component

Hi how to replace inside the tmap component 

 

Say for example 

row1.abcd needs to replaced with row2.abcd 

 

How can we do that inside tmap component?

 

Labels (2)
4 Replies
TRF
Champion II
Champion II

What do you meen?

Can you be a little more explicit?

krengan21
Creator
Creator
Author

row1 needs to replaced with row2 how should i do that inside tmap?

 

TRF
Champion II
Champion II

If the change is on the left side of the tMap, you may also rename the corresponding input flow.

Else you need to make the change manually (no substitute global in tMap - should be great).

navds
Creator II
Creator II

Not very descriptive but let's try.

row1 and row2 need to have a common column to JOIN (default is LEFT OUTER). Then transport all columns in row1 to the tMap output, change column abcd value to row2.abcd (out1.* <=> row1.* ; out1.abcd <=> row2.abcd); don't forget to add an expression filter to your tMap (row2.abcd != null)