Hi -
In the process of learning Power Query and M. I'm loading PDF's from our enterprise system and although the PDF layout is exactly the same for each data pull, sometimes the data comes over into Power Query different. Sometimes the PDF comes over in 13 columns, while other times it comes in 16 columns. I'm merging all the columns of the PDF into 1 column, but my code doesn't work if the source PDF has 16 columns. I've searched for several hours now and can't really find a good answer. Seems like what I've come across involves several steps and I can't believe that this is the easiest way. Below is the m code that I have for the 13 column file. I'm really looking for a line of code that says "merge all columns in the source PDF into 1".
Anybody come across this and found a quick solution?
Thanks,Please Login or Register to view this content.
GRC
Bookmarks