Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Pfa the two qvw files we are using model qvw as a binary load in second qvw .Now we have a requirement like this.:
Target / Subject Requirement Description of the requirement | BHP should be included for the Keywords WCONHIST and WCONINJH |
Solution (optional) For more extensive Problems please refer "Requirement catalog". | For each stated keyword the BHP should be included in the table. WCONHIST – Item 10* = BHP WCONINJH – Item 5* = BHP The following condition shall be used: The BHP shall be included only if the value is defined and above a threshold value of 10. Otherwise it shall be stated as “1*” |
Thanks in advance.Its very urgent
Message was edited by: adarsh chaubey
use the Keep Keyword to reduce the data from your table after the binary load
Refer the below post
Understanding Join, Keep and Concatenate
example
Binary load xxxxxxx;
inner keep(TableName)
Load * INline [
BHP
WCONHIST
WCONINJH
];
Hi Vineeth,
Can you pls explain it more in qvw??
Would be grateful to you.
Regards
Adarsh
After this line add the below script
Binary [..\model\model - txt_export.qvw];
inner keep(TableName) //<< Update the table name in the brackets
Load * INline [
BHP // << The Fieldname by which you want the reduce the data in the table
WCONHIST
WCONINJH
];
the only issue i am getting here is the name of table and also what about this requirement:
For each stated keyword the BHP should be included in the table.
WCONHIST – Item 10* = BHP
WCONINJH – Item 5* = BHP
The following condition shall be used:
The BHP shall be included only if the value is defined and above a threshold value of 10. Otherwise it shall be stated as “1*”
Thanks Vineeth in advance
Anyone its very urgent???I am not able to get the real requirement
@