CODEWITHSUNDEEP
pentaho
tester
tester

Reputation: 223

Merge fields in pentaho

I have two columns "ID_TT" in select values 1 and "ID_ARC" in select values 2.

ID_TT has below values

[blank]

121

[blank]

ID_ARC has below values

146

[blank]

171

I need to merge these two . I used calculator but it does not work. How can we solve this.

output must be

146

121

171

enter image description here

Upvotes: 0

Views: 429

Answers (1)

Venkatesh Panabaka
Venkatesh Panabaka

Reputation: 2154

Here is the solution. I think its useful to you

enter image description here

If you follow above step you can get that result like these.

Result:

enter image description here

Thank you.

Upvotes: 1

Related Questions