Power Query Repeated Column

[cmcreynolds]

I am trying to use part of the filename in the data - I split the column and used delimiters to obtain the text I need. Now I'd like it repeated as I expand the "Content". When I tried this 5 months ago, the text repeated just fine, but now it disappears when I expand the "Content" column.


Here are the lines of code after I removed other columns:

#"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"ClientID", "Content"}),
#"Combined Binaries" = Binary.Combine(#"Removed Other Columns"[Content]),
#"Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter=",",Encoding=1252]),
#"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV"),
#"Changed Type2" = Table.TransformColumnTypes(#"Promoted Headers",{{"First Name", type text}, {"Last Name", type text}, {"Student Number", type text},...etc. But no "ClientID"

Any idea why it wouldn't repeat?

 

[cmcreynolds]

I got it to repeat but in a really weird way -

I created a custom column and used "Excel.Workbook([Content])" to extract that to a table, removed the "Binary" content, but kept my field; then I expanded the "Table" column - THEN it repeated, but I had to promote headers and rename my column, which I'm okay with.

Weird way to solve it and I'm completely open to suggestions as to other ways to do this.

 

[cmcreynolds]

But when I try to add another CSV file to the folder, it blows up. Ugh

However Csv.Document([Content]) seems to help?

Now my issue is that when I then promote headers, it takes the data and promotes it as a header. Renaming it is great except it will always look for that specific data to rename...So, I sorted the data and will hopefully never ever have a ClientID that alphabetically comes before the one I used.