Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
woshua5550
Creator III
Creator III

Load script problem

Hi everyone

I have a table in excel which looks like this:

微信截图_20170118175101.png

but I want to load it as below :

微信截图_20170118175122.png

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

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

thanks a lot

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

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;

Layout_18_Jan_2017.jpg

View solution in original post

3 Replies
trdandamudi
Master II
Master II

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;

Layout_18_Jan_2017.jpg

View solution in original post

woshua5550
Creator III
Creator III
Author

Excellent!!!!!  thx a ton

trdandamudi
Master II
Master II

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