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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Replicating the Last field Value

Hey Community,

I have a two columns in data where one has values till 80 and the other has only 20.

Now I want to replicate the value of 20 in Second column till 80. as below

A     B

1     01    

.      02

.     03

5     04

10     900

11     901

.     .

.     .

.     .

20     910    

.     910

.     910

.     910

.     910

80     910

How can I do that??

Thanks in Advance.

10 Replies
Not applicable
Author

Thank you very much Marco.

It solved some part of the issue.