Combined PowerQuery return null value at one column after changing the datasource

Question

Hi everyone,

I built a query (QUERY in attachement) to combine 3 csv files having differents column headers in one folder called "Datasource". I also told PowerQuery which columns (sample file in attachement) I should have at the result combine query.

- sample coulumns

The query worked well for the inital datasource but when I changed the files/folder, column "actualweight" become null for "delivery" jobname. By right, there should be values at that column if jobname = delivery as in the resource csv file.

Could you please advise what the issues are?

Some interesting observations:

• I tried to re-create the new query with the same issued file then I can see the values
• actualweight seems to appear only for the intial delivery file. whatever is added later would have that column become nul after combining

Google doc link for the source files: https://drive.google.com/drive/folders/1_mUElvdKlQCgpiNyCtgAbkXhscFknFDa?usp=sharing

Answer 1

Hey!

I downloaded the query file and checked your code. It appears to be correct.

I'm not exactly sure I understand what the issue is. Could you please tell us more what you're seeing and what's the output that you're expecting?

You mention that you expect the field "actualweight" to not have null values, but "pickupdump" csv doesn't contain this field so when the combination occurs it'll have null values simply because that field doesn't exist in the field, but your code is explicitly saying that it needs to appear in your final table.