Forum Discussion
Solved
List to column
Hi Team, I am fetching data from web URL and some data is showing as List. Basically these are IPs. Refer below snap Here list is having more than one IP in List. Now I would like t...
Hi vishnusingh ,
This:
let Source = Table.FromRecords({ [ip = "192.168.1.1"], [ip = Table.ToList(Table.FromRecords({[ip = "10.168.1.2"],[ip = "10.168.1.3"]}))], [ip = "22.168.1.4"]}), #"Added Custom" = Table.AddColumn(Source, "Custom", each if Type.Is(Value.Type([ip]),type list) then [ip] else {[ip]}), #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}), #"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"ip"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "ip"}}) in #"Renamed Columns"Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We are almost close however we would require these IPs in the same column as comma/semi-colon separated not in a new column.
v-chenwuz-msft
Community Support
Community SupportHi vishnusingh ,
This:
let
Source = Table.FromRecords({
[ip = "192.168.1.1"],
[ip = Table.ToList(Table.FromRecords({[ip = "10.168.1.2"],[ip = "10.168.1.3"]}))],
[ip = "22.168.1.4"]}),
#"Added Custom" = Table.AddColumn(Source, "Custom", each if Type.Is(Value.Type([ip]),type list) then [ip] else {[ip]}),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
#"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"ip"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "ip"}})
in
#"Renamed Columns"
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.