cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
data25
Level: Powered On

converting one column table to multiple columns table

I have a table which has one column  named "id/name/age" and  some rows ,"1/xxx/23", "2/yyy/33", "3/zzz/55".... 

 

I'm trying converting this table to new table which has three columns, "id", "name", "age". I guess I should use Split(), AddColumns().

 

Do you have any idea? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: converting one column table to multiple columns table

Hi @data25

 

My inclination would be to split the data at the data source level. Perhaps you use a data source that supports computed columns?

 

Failing that, here's the syntax you would use that incorporates the AddColumns and Split functions.

 

AddColumns(myDataSource,
           "ID", First(Split(IdNameAgeColumn, "/")).Result,
           "Name", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 2)).Result,
           "Age", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 3)).Result
)

Hope that helps.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: converting one column table to multiple columns table

Hi @data25

 

My inclination would be to split the data at the data source level. Perhaps you use a data source that supports computed columns?

 

Failing that, here's the syntax you would use that incorporates the AddColumns and Split functions.

 

AddColumns(myDataSource,
           "ID", First(Split(IdNameAgeColumn, "/")).Result,
           "Name", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 2)).Result,
           "Age", Last(FirstN(Split(IdNameAgeColumn, "/").Result, 3)).Result
)

Hope that helps.

View solution in original post

data25
Level: Powered On

Re: converting one column table to multiple columns table

Thank you very much for your answer ! It works as expected !

I always use Google Sheet as datasource, but in case this I faced 6 columns limitation, so I concatenate multiple columns in Google Sheet before powerapps, and then split 6 columns again. 

That's why I'd like to know this.

Thank you!

Super User
Super User

Re: converting one column table to multiple columns table

Thanks for clarifying the Google Sheet data source. I'm very glad the formula works for you.

CP0822
Level: Powered On

Re: converting one column table to multiple columns table

Hi,

 

I'm trying to do something very similar. I have one textinput where the user paste a data from Excel.

 

I want to save this information in a collection with multiple columns, this is my code right now

 

Collect(
TestColl;
Split(
Substitute(TextInput3.Text;Char(9);"/");
Char(10)
)
);;AddColumns(TestColl;"Fase";First(Split(Result;"/").Result).Result;"Done"; Last(FirstN(Split(Result; "/").Result; 2)).Result)

 

This is what I'm getting right now, any ideas?

 

Example1.JPG

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,944)