Load script problem

[woshua5550]

Hi everyone

I have a table in excel which looks like this:

but I want to load it as below :

"T2" equal to "T1" when "ID" -1

how does the load script should be looks like ? plz help

thanks a lot

[trdandamudi · Accepted solution]

May be as below:

Source_Data:

Load * Inline [

ID,T1

1,A

2,B

3,C

4,D

5,E

];

NoConcatenate

Final:

Load

ID,

T1,

If(ID=1,'',Previous(T1)) as T2

Resident Source_Data;

Drop Table Source_Data;

[woshua5550]

Excellent!!!!!  thx a ton

[trdandamudi]

Awesome.... Glad able to help out...