Hi,
I am using the formula
#"Prefix" = Table.PrefixColumns(Sheet1_Sheet, "EPL")
to add the prefix "EPL" to my columns. It adds the prefix but instead of keeping the old name, renames each column "column".
So I get
EPL.Column1 EPL.Column2 EPL.column3 ...
instead of
EPL.Date EPL.Debit EPL.Credit ...
What am I doing wrong?
you didn't post example excel fileOriginally Posted by Wrast
Attached ("extract dummy" is what the raw file looks like and "dummy file" is the one that I'm loading data into and has the request.
Basically it looks like it does not recognize the first row as column names and so adds a row. I tried to load as table and not "sheet", but am new to PQ and cannot figure it out.
Thank you
extract dummy.xlsx
dummy file.xlsx
Last edited by Wrast; 05-25-2023 at 01:47 PM.
Probably like
Please Login or Register to view this content.
and filter by null to not generate whole sheet of empty data
Thank you!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks