Forum Discussion
Data left to right
- 5 years ago
Hello netanel
you are almost there. Just replace the changed type at the very end of your code with Reverse. Be aware, its case sensitive...
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello netanel
you can transform you column (you could basically also add a custom column, but that would only make more unneccessary data) and apply the function in my code
Reverse = Table.TransformColumns
(
#"Changed Type",
{
{
"YourColumn",
each Text.Combine(List.Reverse(Text.ToList(_))),
type text
}
}
)
if you need more columns to be transformed, you have to add a another nested list. In case I can show you that too. Here a complete code example to see how it works
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WckxKVkhJTbNXitWJVvLPSFSoSElUio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YourColumn = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"YourColumn", type text}}),
Reverse = Table.TransformColumns
(
#"Changed Type",
{
{
"YourColumn",
each Text.Combine(List.Reverse(Text.ToList(_))),
type text
}
}
)
in
Reverse
transforms this
into this
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
hi, you can also bring me the M function (custom column)
just to see if its solve my problem
thanks