Create field combining two fields based on another field

[gbessern]

Hi,

I need help to combine tables. I have two tables:

CustomField	Key2	Multiple	Value
A	x	-	1
B	y	-	2
C	z	Yes	-
C	z	Yes	-

Key2	Values
z	3
z	4

I need to create a third table like:

CustomField	Value
A	1
B	2
C	3
C	4

Is there a script fuction to do this?

[y_grynechko]

Good Morning,

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...