Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Dynamic Column Name (M/PowerQuery) Difficulty

Hi all,

 

I am importing many files (with the same structure from a folder). These files automatically append to each other.

 

I required to change  one of the column names based on it's index position. (as when new files are added to the folder I can't be certain the same file is going to be taken as the first file. This could lead to the column header name to being different.

 

= Table.RenameColumns(#"Promoted Headers",{{Table.ColumnNames(#"Promoted Headers"){28}, "--1"}})

I succesfully changed the column header name. Everything is good up until this point! 

 

However, if the column name is already --1. (The name I am trying to change to) PowerBI will return an error saying:

 

Expression.Error: The field '--1' already exists in the record.
Details:
Name=--1
Value=

 

I considered using a conditional formula inside of this where I would say If = -1, take the previous query. This isn't working and even if it is, I need to replicate this rename column for 5 columns. I can't take the previous query because it depends on which ones worked.

 

Sorry If this isn't clear, I can try clarify if the question again.

 

Thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Solution:
When you import fikes from Share point a sample file is created. You can set which file you like to be selected as your first query.

I can now ensure my first query containta the relevant headers 🙂

(For the if statement, I still cant set the word as it will say you already have this word)

View solution in original post

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Could you please tell us what's the problem you meet when using the if function?

Best Regards,

Teige

Anonymous
Not applicable

Solution:
When you import fikes from Share point a sample file is created. You can set which file you like to be selected as your first query.

I can now ensure my first query containta the relevant headers 🙂

(For the if statement, I still cant set the word as it will say you already have this word)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors