Logical help

[Anonymous]

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

[vinieme12]

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

];

[Anonymous]

Hi Vineeth,

Can you pls explain it more in qvw??

Would be grateful to you.

Regards

Adarsh

[vinieme12]

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

];

[Anonymous]

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

[Anonymous]

Anyone its very urgent???I am not able to get the real requirement

[Anonymous]

@

Irena Calovska