Fill blanks fields with linked table value

[#1]

Hello,

I'm new in qlikview and I wanted to kno if someone can help me in finding the solution of:

I got 3 linked tables 1, 2 ,3 from 3 excel files.

The second table has a field called PN with blanks values and the way to get values is to use CNN field and get the same line PN value in the table 3.

Table 2                                    Table 3                                                  Table 2

PN with blanks

CNN >>>>>>>>>>>>>>>>>>CNN>>PN (one or some) >>>>>>>>>>>PN (gathered separated by ";" if more than 1 PN)

If some one knows how to do that, or what functions to use in the console window it would be nice.

Thankx