Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Functionality of function Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Top, 3), Select(1, 3)))

Hi,

i wanted to reduce rows while loading from excel. I tried Using enable transformation and conditional delete but I ended up with a code as below,

INPUT:

  

member_biz_keyagegender
110A
220B
330C
440D

CODE:

LOAD member_biz_key,

     age,

     gender

FROM

Member.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Top, 3), Select(1, 3)))

));

OUTPUT:

member_biz_keyagegender
220B
330C
440D

Can someone explain how it works ?

Thanks!

1 Solution
7 Replies
Highlighted
Master II
Master II

try like this:

INPUT:

LOAD * INLINE [

member_biz_key, age, gender

1, 10, A

2, 20, B

3, 30, C

4, 40, D

] where gender<> 'A';

Highlighted
Creator II
Creator II

Hi,

Actually I wanted to know the functionality of this smaller input on how it works. But I have so much records in my project.

Thanks for your answer anyways.

Highlighted
Creator II
Creator II

thanks stefan

Highlighted
Creator II
Creator II

Hi,

One more doubt is, how do I load only the data like this as output ?

input:

member_biz_keyagegender
110A
220B
330C
440D

Output: ONLY THE PARTICULAR FIELDS WITH DATA:

agegender
30C
40D
Highlighted
MVP
MVP

If you don't want the member_biz_key field, just remove it from the LOAD statement.

What's the rule behind loading only these two rows? Is it based on age, gender, both or row number?

Highlighted
Creator II
Creator II

Hi stefan,

It is like just an example that i want to load only the particular data. i.e;data from A1 to C5 in above table - Load only  from cell B4(age 30) in excel  to C5(gender D) removing A column and first 2 records of B cells and C cells as well..