Forum Discussion
Solved
Columns connecting
Hi, I don't know how to fix my data. I want to have 2 columns, first with ID number, and second with link. Now it looks like that: I want to add "Issue number_1" to the "Issue number" and ...
This is how you can get it all into one column.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUcooKSkottLXLy8v10tMStZLzs8FihrhkInViVYyxqnLBI8uU5y6zHDpigUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [IssueNumber = _t, Image = _t, IssueNumber_1 = _t, Image_1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"IssueNumber", Int64.Type}, {"Image", type text}, {"IssueNumber_1", Int64.Type}, {"Image_1", type text}}), TableToColumns = Table.ToColumns( #"Changed Type" ), IssueNumbers = List.Combine ( { TableToColumns{0}, TableToColumns{2} } ), Images = List.Combine ( { TableToColumns{1}, TableToColumns{3} } ), ListColumns = { IssueNumbers, Images }, TableFromColumns = Table.FromColumns ( ListColumns ), #"Sorted Rows" = Table.Sort(TableFromColumns,{{"Column1", Order.Ascending}}), #"Renamed Columns" = Table.RenameColumns(#"Sorted Rows",{{"Column1", "IssueNumber"}, {"Column2", "Image"}}), #"Added Custom" = Table.AddColumn(#"Renamed Columns", "Custom", each "ImageNumber " & Number.ToText ( [IssueNumber] ) & " " & [Image], type text) in #"Added Custom"
