PQ not pulling in dates from 1 file

[Craigc3814]

I am having an issue with PQ bringing in the due date from one file. I use it to combine excel files from a network folder using FNGetContents from Ken Puls site. every file is identical but for whatever reason on this months file it has decided to no longer bringing in the due date field. It just brings in null.

 

[Craigc3814]

Figured it out, they changed a few words in the column heading to starting with capital letters. is there a way to not make PQ less picky?

 

[MarcelBeug]

You might rename your columns based on column number at the start of your query with the function in this topic.

 

[Craigc3814]

As always thanks Marcel