Fill empty cells in field

[#1]

Hi all,

I have a file with a field 'Code internal/external', but some cells are blank. An example is shown below.

Portfolio 1	Portfolio 2	Portfolio 3	Code internal/external
A			Internal
	BB		Internal
		CCCC
D			External
	CC		Bla

I want to fill the empty cells in the field internal/external according to an excel file, not by inserting portfolio names in the script since in reality the portfolios have complex names. Therefore everything has to go through the excel file. The excel file looks something like below:

Portfolio 1	Portfolio 2	Portfolio 3	Internal/external
A	AA	AAA	Internal
B	BB	BBB	Internal
C	CC	CCC	External
D	DD	DDD	External

Is it possible to fill the blank cells in the first table according to the excel file? In this case, portfolio 1 2 or 3 signifies whether it is internal or external.

In addition, some fields are filled with nonsense names. I want to substitute names other than Internal or External according to the excel file. In above case, this is 'Bla'.

Thank you in advance.

Lance

[#2]

Hi,

we can use alternate logic,

Ex:

PFA

Here I have taken Excel like data as below,

EXCEL:

LOAD * INLINE [

    p1, p2, Flag

    A, QQ, IV

    B, AA, IV

    B, PP, NV

    C, CC, IV

];

And Your Main Table Missing data as below,

Test:

LOAD * INLINE [

    p1, p2, Flag

    A, , IV

    , AA, IV

    B, , NV

    C, CC,

];

Please find solution you can create Key for both table & after that just join the table..

please provide your sample data if you can here else email at harshal.patil457@gmail.com

Regards,

Harshal