Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rowno(), RecNo() ,Table not found

Thanks

Madhu

Labels (1)
1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

It is coming from Table1.. You forgot to drop that table..

Table1:

Load * Inline

[

  A, B

  1, aa

  2, bb

  3, cc

];

Table2:

Load * Inline

[

  A, B

  4, xx

  5, yy

  6, zz

];

TAB:

Load *, RecNo(), RowNo() Resident Table1

Where A<>2;

Drop Table Table1;

View solution in original post

3 Replies
MK_QSL
MVP
MVP

It is coming from Table1.. You forgot to drop that table..

Table1:

Load * Inline

[

  A, B

  1, aa

  2, bb

  3, cc

];

Table2:

Load * Inline

[

  A, B

  4, xx

  5, yy

  6, zz

];

TAB:

Load *, RecNo(), RowNo() Resident Table1

Where A<>2;

Drop Table Table1;

Anonymous
Not applicable
Author

Hi Josna,

Please elaborate on your requirement,just query doesn't give enough information.

Regards

Neetha

Not applicable
Author

can see the Query document in the document i mentioned  what i want

Thanks

Madhu