Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Splitting Columns into Individual rows and mapping with corresponsing values in the table

Hi Team,   I have a table with countries & savings forecast. I need to split it into individual rows and map the values int eh forecast & actuals table withteh corresponding country names. Can you ...
Need Help
Show and Tell
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    Hello Anonymous 

    Add As custom column 
    1> Text.Split([Country] , ",")
    2> Text.Split([Cost Savings Forecast] , ",")

    3> Text.Split([Cost Savings Actual] , ",")

     

    after delete original column then ADD Custom Column 
    Table.FromColumns({[Country.1],[Cost Savings Forecast.1],[Cost Savings Actual.1]})

    before Expanded Table Delete Created Custome Column And then Expand Table column end you get your result .

    Thank you ,

    Mahesh patel

  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    Anonymous 

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Hello Anonymous 

Add As custom column 
1> Text.Split([Country] , ",")
2> Text.Split([Cost Savings Forecast] , ",")

3> Text.Split([Cost Savings Actual] , ",")

 

after delete original column then ADD Custom Column 
Table.FromColumns({[Country.1],[Cost Savings Forecast.1],[Cost Savings Actual.1]})

before Expanded Table Delete Created Custome Column And then Expand Table column end you get your result .

Thank you ,

Mahesh patel

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks Mahesh. The solution worked. 

     

    This is what I was looking for earlier. I have been trying different queries, but eventually none of them worked