Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rootsmusic
Helper I
Helper I

split into rows

My query connected to a .txt file, which has the following line:

 

 

elections_to_vest_changes = {'119WEST BUFFALO': '119000210WEST BUFFALO', '119UNION': '119000200UNION', '119NEW BERLIN': '119000190NEW BERLIN'}

 

The single quotation marks enclose text.  The colon is a delimiter for a column.  The comma is a delimiter for a row.

 

(I've shortened this line for readability.)  How can I split this line by delimiter into rows?  Thanks.

1 ACCEPTED SOLUTION
serpiva64
Super User
Super User

Hi,

if something like this is what you need

serpiva64_0-1649797493370.png

you have first to split by delimiter in rows

serpiva64_1-1649797538831.png

then split by delimiter in columns

serpiva64_2-1649797573328.png

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

 

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

 

Save your text in a json file, transforming '(single quote) into "(double quote) and use the following script to transform it into a table with two columns and many rows

 

 

let
    Source = Json.Document(File.Contents("C:\Users\sprmn\OneDrive\Documents\Power BI Desktop\test.json")),
    tfc=Table.FromColumns({Record.FieldNames(Source{0}),Record.FieldValues(Source{0})})
in
    tfc

 

 

serpiva64
Super User
Super User

Hi,

if something like this is what you need

serpiva64_0-1649797493370.png

you have first to split by delimiter in rows

serpiva64_1-1649797538831.png

then split by delimiter in columns

serpiva64_2-1649797573328.png

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors