topic Re: Load script problem in QlikView

Load script problem

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 18 Jan 2017 10:32:49 GMT

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 — Wed, 18 Jan 2017 10:44:45 GMT

Excellent!!!!! thx a ton

trdandamudi — Wed, 18 Jan 2017 10:46:23 GMT

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