Autofill column with one single field

[#1]

Hi all:

I receive the same table every month. The format is the same, so they autoconcatenate. The problem I have is that some of the fields are empty and I'd like to fill them with the monthly value of every table.

After my load, I have this table:

FECHA	CS_AD_CO_RANGO_INFERIOR	CS_AD_CO_INDICADOR
31/01/2015	0,75	CO
	0,5	CO
	0	CO
28/02/2015	0,75	CO
	0,5	CO
	0	CO
31/03/2015	0,75	CO
	0,5	CO
	0	CO

And I'd like to get this:

FECHA	CS_AD_CO_RANGO_INFERIOR	CS_AD_CO_INDICADOR
31/01/2015	0,75	CO
31/01/2015	0,5	CO
31/01/2015	0	CO
28/02/2015	0,75	CO
28/02/2015	0,5	CO
28/02/2015	0	CO
31/03/2015	0,75	CO
31/03/2015	0,5	CO
31/03/2015	0	CO

How could I fill the empty cells of the FECHA column with their corresponding value?

Thanks a lot for your help!!

Regards,

Vincent

[sunny_talwar]

May be something like this?

If(Len(Trim(FECHA)) = 0, Previous('FECHA'), FECHA) as FECHA

[#3]

Not yet at all... it has just filled one of the two empty fields. 😞

Thanks anyway for your help Sunny! If you have another idea, I'll be happy to ear it!

[sunny_talwar]

Can you try it with Peek() Instead of Previous may be

If(Len(Trim(FECHA)) = 0, Peek('FECHA'), FECHA) as FECHA

or this:

If(Len(Trim(FECHA)) = 0, Peek('FECHA1'), FECHA) as FECHA1

[tamilarasu · Accepted solution]

Hi Vincent,

You can fill empty cells by using file wizard. Use enable transformation step, there you can see fill option. Just click and enter the colum number in popup boc and select "is empty" by using cell condition button.

[#6]

I've just tried it Tamil and it works!! Thanks a lot for your help!!

[tamilarasu]

You are welcome Vincent.