Hi Mynda, I am sending a file, so you can see where I made a mistake. I tried to merge the 'parts number' column in 'Parts' with the 'Total approved parts amount'. 

Here is what I did:

1. Made a connection only query called "Parts" for Parts number

2. Made a connection only query called " UDIS_JS_append_filter" containing parts number and Total approved parts amount

3. Right click on the Parts to merge

4. Selected "UDIS_JS_append_filter" 

5. Selected parts on both query

6. Selected Left outer merge

7. Clicked okay

8. I clicked "expand" to open the table 

But the result was null

Can you explain about the difference between "expand " and "aggregate"??

File could not be attached because it was big.

But when I manually filter the there should be result and not null

Do you have any ideas to how I can go about it in another way?