[SOLVED] Appedning Power Queries, not all values added

[leukep]

Hi all,

When appending 3 queries to 1, I'm having problems with the data with 1 of the queries with no clear reason.

Below you'll see the original query took 2 values under the example name
2017-06-20_11-35-55.jpg

When appending queries, I get the following result:
2017-06-20_11-36-32.jpg

Why could this be happening? how is this solvable?

Kind regards,

Robbe

[Olly]

Post your queries.

[leukep]

Hereby the files.

You'll find the queries in the data overview file
and I added the data for query "GNT" (where the problem is situated)

the query combining all is "together query"

Regards,

robbe

[leukep]

Anyone? I'm really stuck here!

[xlnitwit]

Hi,

One of the rows has "yes" for delivered but the other has "yes " with a trailing space and thus is excluded by your filter.

[leukep]

Hi,

yes, but that is trimmed down in the together query.
and is not related to the above question ?

[xlnitwit]

yes, but that is trimmed down in the together query.

I do not see anywhere that you remove the spaces from that field.

and is not related to the above question ?

Quite the contrary- it is exactly why you only see one of the two records in your combined query. The combined query filters that column for "yes" and only one of the two rows matches that, since the other contains "yes ".

[leukep]

Great! Didnt know this would keep rows from disappearing
thank you!

So only if values appear in 2 or more of the underlying queries, the row will show ?

regards,

[xlnitwit]

No, it's a simple append query which will produce all rows from all the source queries. It's just the filter you applied that was removing records.

[leukep]

Ok,

I dont see a filter set in the row column title.
Neither in the advanced editor.

I trimmed down now all rows, but now other values are not showing up (only see the yes values while others should show up too)

regards

[xlnitwit]

Step 'Filtered Rows1' of your Together Query is:

= Table.SelectRows(#"Capitalized Each Word1", each ([#"Delivered?"] = "Yes"))

which restricts the output to only rows where the "Delivered?" column is "yes".

[leukep]

Aaah indeed!
Great help! thank you very much!