converting one column table to multiple columns table

[data25]

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? 

[timl · Accepted solution]

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.

[data25]

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!

[timl]

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

[CP0822]

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?