can you supply some dummy data to illustrate the problem please ?
Hi Mavis, Chris,
This is the snapshot of sample data
1. Shift Start has been linked. Mavis, icon has been changed to "linked"
2. "Month_Code" in Table 2 is not linked
3. Chris, if i create dummy data, the blending works. But it seems (i can't be sure) it doesn't work with live connection to oracle db. is there a limitation to oracle db?
tan wt wrote:
if i create dummy data, the blending works. But it seems (i can't be sure) it doesn't work with live connection to oracle db. is there a limitation to oracle db?
Ah right, so that's the key right there It's something that Oracle is doing that Excel (I'm guessing that's your dummy data) isn't doing.
Can you create some dummy tables in Oracle (to test, not for posting here).
Also, it's worth looking at the datatype differences - specifically DATE vs DATETIME . It might work if all fileds are DATETIME, but it might not work if you're mixing them
i don't have access to oracle db. i can only read
i did an experiment whereby i use "table 2 - shift date" + "table 1 - Quantity". this works. So i don't think it is date data type issue
But when i use "table 2 - month_code" + "table 1 - Quantity", the quantity sum the entire population
my observation is data blending only works on the actual linked fields
kinda frustrated right now
very weird can you attach the spreadsheet with your dummy data, or better still the XLS & a workbook showing where it's not working.
It should work fine I thought.
I have done extra testing
it seems the issue is related to datetime link which i haven't figure out the solution
the reason i said so is because when i try to blend with non date fields, it seems to work