Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have two qvd files
1 . EMP.QVD ( Giving time consumend by staff to compltete job)
2. TOT_VOLUME.QVD ( Volume of work unots in Nos)
I want to create a file combining two files to calculate voume handle by staff members ( Receipt Nos and Debit Note Nos from volume file should be multified by Minutes from Emp file based on SEQ )
I have tried doing this using apply map method but It does not work properly. Pls help me to do it. I have attached my QV document and two data files pls.
What is the expected output here? You have Multiple BCOD and NOS in your applymap.... Which one should be picked?
Expected output is as follows If there is a value in Debit Notes or Dir Receipts It should be multified by Minutes.
But my problem is all records in Tot Volume is not returned whemn apply map is used
BCOD | DEBIT_NOTES | SEQ | DIR_RECEIPTS | MINUTES | Output |
VU00 | 7 | 12 | 0.5 | 6 | |
VU00 | 8 | 12 | 0.5 | 6 | |
VU00 | 11 | 12 | 1 | 12 | |
AA00 | 7 | 39 | 0.5 | 19.5 | |
AA00 | 8 | 39 | 0.5 | 19.5 | |
AA00 | 11 | 39 | 1 | 39 | |
AA00 | 22 | 9 | 0.5 | 11 | |
VU00 | 110 | 9 | 0.5 | 55 |
Can some one pls help me to solve my issue