Split multiple columns into multiple columns

[yogeshYS]

Hi,

I have a DB where in a column will hold data delimited by a COMMA and this kind of data is present in more than one column. I want to split all of these columns into multiple columns. I tried the option of split Column, but this will do only one column and i cannot select more than one column. 

Is there a way to bring into the script to select multiple columns and rename it by selecting a particular data in a array of strings?

Also, the columns in the DB tabel resluts_table is named as Item_0, Item_1 and goes on till Item_x. The actual name for these columns is stored in another table called Map_table with a comma delemit. I need to read from the data from Map_table and store it in array of strings. Then rename the columns in results_table to the data present in the array of strings.

Is there a way to achive above two requirments in PowerBI desktop?

Thanks.

[v-yulgu-msft]

Hi @yogeshYS,

From my understanding, to achieve your reqirement with Power Query, you might have to write custom function which is not an easy work. In this scenario, I think splitting columns manually is much easier and spending less time than developing a complex custom function.

Regards,

Yuliana Gu

[yogeshYS]

@v-yulgu-msft

I have around 400+ columns to rename and split. 

So manual operation will be a tedious job. So, i am still exporing how to automate this process.