Create a db on demand of client.

[sona_sa]

Hi,

I have two column.

AA	BB	OutPut
1	a	a
1	a	a
1		a
2	b	b
2		b
3	c	c
3	c	c
3		c

Now I have for 1 ->a and in some place 1 -> null so on the place of null I want a

Similarly for 2 ->b and in some place 2 -> null so on the place of null I want b

Similarly for 3 ->c and in some place 3 -> null so on the place of null I want c

Please find the attached xls for example.

Thanks

A Kumar

[CELAMBARASAN]

Hi,

     Try with this approach

Table:

LOAD [AA    ],

     OutPut

FROM

Test.xls

(biff, embedded labels, table is Sheet1$);

Table1:

Load Distinct

[AA    ],

     BB

FROM

Test.xls

(biff, embedded labels, table is Sheet1$) Where BB<>null();

Left Join(Table)

Load

          *

Resident

Table1;

DROP Table Table1;

Hope it helps

Celambarasan

[sona_sa]

Hi Celambarasan

I don't have any field like Output. I have created it for help.

I have only two column i.e AA and BB. Now we have to create a column like output with the help of this AA and BB Column.

Thanks for revert.

[CELAMBARASAN · Accepted solution]

Hi,

     Sorry I understood wrongly.

     Use this

Table:

LOAD [AA    ],

     BB

FROM

[..\My Documents\Downloads\Test.xls]

(biff, embedded labels, table is Sheet1$);

LOAD

          [AA    ],

     BB,

     if(BB<>Null(),BB,Previous(BB)) as OutPut

Resident Table;

DROP Table Table;

Celambarasan

[sona_sa]

Thanks.

Don't say sorry, It was my mistake, I didn't mentioned it.

Thanks again.

A Kumar