Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Split file based on row content

I've got a csv file I'm importing into desktop. I've got multiple rows per student and rather than splitting the report coming from the MIS for each school I wondered if there was an easy way to split all the rows with TP Year 1 for example into another table, keeping all the other rows?

 

Keeping top / bottom X rows wouldn't work as the file increases in size throughout the year.

 

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    In Power Query Editor, right click the table in Queries and select Duplicate to make a copy of the table. 

    Then in the new query, expand the down arrow and select the text values to filter the rows.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , In power query, create a copy of table and filter the table based on text search and save.

     

    In dax create a new table

    CALCULATABLE(Table, filter(Table, search("TP Year 1 ",Table[resultset],,0) >0))

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

    In Power Query Editor, right click the table in Queries and select Duplicate to make a copy of the table. 

    Then in the new query, expand the down arrow and select the text values to filter the rows.

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.