Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Let's see:
Your mapping table here...
Load Emp_id,
Emp_Name
From Qvd...
Where Name=Applymap('xxxx',Emp_id);
What if I would like to load all the rows of inline table??
direct you can load with Emp name
Load Emp_id,
Emp_Name
From Qvd...
Where Name='A' ;
store tablename into path ;
EmployeeDetails:
Load *
where Name='A';
LOAD * INLINE [
EmployeeId,Name
1,A
2,B
];
store EmployeeDetails into path/EmployeeDetails.qvd (qvd);