Forum Discussion

memoalkatib1's avatar
memoalkatib1
Frequent Visitor
2 years ago

Table.Split( ) need to split one flat table into multiple tables

Hi There,    I'm importing an excel sheet that has a list of tables in the format of rows and columns . I found an article that almost solves my impediment using table.Split () . but the function o...
Need Help
slorin's avatar
slorin
Super User
2 years ago

Hi

 

Group by Value

 

= Table.Group(Source, {"Value"}, {{"Data", each _}})

Stéphane 

memoalkatib1's avatar
memoalkatib1
Frequent Visitor
2 years ago

I did that in a previous approach , but never got to how to expand the tables after this step. the grouping leaves me with this "Table" or view:

Value                           Data
S_SPONSOR_ID           Table
S_ORGANIZATION       Table
S_ORGTYPE                  Table

If I just save this as is I get the message : Expression.Error: We cannot convert a value of type Table to type Text.

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago

    memoalkatib1 use slorin_table[Data] to get a list of tables. Table.Split gives the same structure - a list of tables and you're happy with that. What did you want to get in the end? 

    • memoalkatib1's avatar
      memoalkatib1
      Frequent Visitor
      2 years ago

      The grouping will give me 2 columns in the form of a list. no ? identical to this breakdown : 

      Value                           Data
      S_SPONSOR_ID           Table
      S_ORGANIZATION       Table
      S_ORGTYPE                  Table

      my question. what do I do after this step ? because I have yet to create individual tables for each row in the above example. so what would be the next stage?  table. split (source, 1) ? the Data column contains individual tables and I need to step in and transform those into stand alone tables and not have it as a list as shown above

      • AlienSx's avatar
        AlienSx
        Super User
        2 years ago

        memoalkatib1 the only way to get 3 separate tables is to create 3 queries with tbl[Data]{0}, tbl[Data]{1} and tbl[Data]{2}