Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎11-23-2018
Accepted Solution

How to select all the columns at once

Hi,

 

I'm new on Power BI  and I'm trying to change the type of datas from "text" to "number".

Here are the steps that I follow:

1. Change all the points (.) in commas (,)

2. Change the datas' type from "text" to "decimal"

 

The problem is that when I change the data source, the columns names change and i have to change manually the columns' names to match the ones that are in the new database.

e.g.:

  #"Valeur remplacée" = Table.ReplaceValue(#"Valeur remplacée2",".",",",Replacer.ReplaceText,{"Floor Area (m²) (Real)", "AE #1 Max. Flow (ac/hr) (Real)", "AE #1 Max. Flow (l/s) (Real)", "AE #1 Max. Flow (l/(s·m²)) (Real)", "AE #1 Max. Flow (l/s/person) (Real)", "AE #2 Max. Flow (ac/hr) (Real)", "AE #2 Max. Flow (l/s) (Real)", "AE #2 Max. Flow (l/(s·m²)) (Real)", "AE #2 Max. Flow (l/s/person) (Real)", "Gain 1 Max. Sensible Gain (W/m²) (Real)", "Gain 1 Max. Sensible Gain (W) (Real)"}),

 

If the new database doesn't contain the column "Floor Area (m²) (Real)", I can't execute the step "#Valeur remplacée"

 

The only solution that can help me in to select all the table instead of a list of columns.

 

Can somebody help me with this?

Thanks in advance.


Accepted Solutions
Super User
Posts: 10,513
Registered: ‎07-11-2015

Re: How to select all the columns at once

Perhaps try getting rid of the Promoted Headers step and just deal with the default names of the columns? Then, promote the headers at the very end.

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


View solution in original post


All Replies
Super User
Posts: 10,513
Registered: ‎07-11-2015

Re: How to select all the columns at once

Perhaps try getting rid of the Promoted Headers step and just deal with the default names of the columns? Then, promote the headers at the very end.

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Posts: 7,645
Registered: ‎05-02-2017

Re: How to select all the columns at once

Hi @Whatslife,

 

Greg could have the best solution. Since the column names are changed, I, the human, don't know which column is which one if I have your data. Power BI couldn't know it either.

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 2
Registered: ‎11-23-2018

Re: How to select all the columns at once

Thanks a lot. I didn't notice that promoting headers will automatically detect the data type if they are in a common form.

Thanks again!