All, Have a confusion.
I have one query in db2 which (Source 1) looks like,
DATE,COUNTRY,PRODUCT,NUMOFPRODUCTS
There are total 200 rows with product count Country and Product wise.
Source 2 - DB2, looks like,
DATE,COUNTRY,PRODUCT,NUMOFPRODUCTSFILTERED
but it has a filter so number of records are 100.
How we can combine these two. The final excel file should look like,
DATE,COUNTRY,PRODUCT,NUMOFPRODUCTS,NUMOFPRODUCTSFILTERED.
I used merged stages before where Product and Country were same number of records. But here i cant merged based on any key as total rows differ.
Appreciate your help.
Merge/Join Stage
Moderators: chulett, rschirm, roy
From what I recall, those 'errors' are normal when (for example) there is no matching master record and they would go down the reject link you should have in place. And apparently you should get 100 of them. Ignore them. Do you get the 100 that you want as well, not rejected?
And the Merge stage requires there be no duplicates in the data.
And the Merge stage requires there be no duplicates in the data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
It's hard for anyone to say anything other than 'ensure there are no data issues that will cause rejects'. Look at why those 16 (that I assume you think shouldn't be) are getting rejected and see what you can do about them. Design issue? Settings? Data?
If you need more help we would need much more in the way of gory details to be able to help out intelligently...
If you need more help we would need much more in the way of gory details to be able to help out intelligently...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers