Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use inline table for where condition

For example I have loaded the following inline table:

EmployeeDetails:

MAPPING LOAD * INLINE [

   EmployeeId,Name

   1,A

   2,B

];

I would like to have the details of  EmployeeId 1 into one qvd,

How is that possible?

Like, I want to load only the details of Employee A.and store it into qvd

4 Replies
jolivares
Specialist
Specialist

Let's see:

Your mapping table here...

Load Emp_id,

Emp_Name

From Qvd...

Where Name=Applymap('xxxx',Emp_id);

Anonymous
Not applicable
Author

What if I would like to load all the rows of inline table??

Chanty4u
MVP
MVP

direct you can load with Emp name  

Load Emp_id,

Emp_Name

From Qvd...

Where Name='A' ;

store tablename into path ;

krishna_2644
Specialist III
Specialist III

EmployeeDetails:

Load *

where  Name='A';

LOAD * INLINE [

   EmployeeId,Name

   1,A

   2,B

];

store EmployeeDetails into path/EmployeeDetails.qvd (qvd);