Fill blanks fields with linked table value

Tue, 16 Apr 2013 09:11:03 GMT

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

topic Fill blanks fields with linked table value in QlikView

Fill blanks fields with linked table value