topic Re: How to use inline table for where condition in QlikView

How to use inline table for where condition

Anonymous — Wed, 14 Mar 2018 11:37:14 GMT

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

Re: How to use inline table for where condition

jolivares — Wed, 14 Mar 2018 16:16:03 GMT

Let's see:

Your mapping table here...

Load Emp_id,

Emp_Name

From Qvd...

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

Re: How to use inline table for where condition

Anonymous — Thu, 15 Mar 2018 03:41:29 GMT

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

Re: How to use inline table for where condition

Chanty4u — Fri, 16 Mar 2018 07:05:11 GMT

direct you can load with Emp name

Load Emp_id,

Emp_Name

From Qvd...

Where Name='A' ;

store tablename into path ;

Re: How to use inline table for where condition

Qrishna — Fri, 16 Mar 2018 08:00:51 GMT

EmployeeDetails:

Load *

where Name='A';

LOAD * INLINE [

EmployeeId,Name

1,A

2,B

];

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