Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Steps to re-create on April and May versions. PBIX is attached.
OK, this is bizarre but there is some strange behavior going on with CONCATENATEX. Steps to recreate:
1. Create the following tables in Power Query, Table, Table2 and Table3:
Table:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFOK1QEySnMyU8GsgMRcpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}})
in
#"Changed Type"
You will have in your table:
John
Julie
Pam
Table2:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8s3MTlWK1YlW8srPyIMwSnMyIUIBiblKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}})
in
#"Changed Type"
You will have in your table:
Mike
John
Julie
Pam
Table3:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8srPyFOK1QEySnMyU8GsgMRcMO2bmQ0UiAUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Name"}})
in
#"Renamed Columns"
You will have in your table:
John
Julie
Pam
Mike
2. Now create the following column in each table:
Name Again =
VAR __Value = [Name]
VAR __Table =
ADDCOLUMNS(
GENERATESERIES(1,LEN(__Value),1),
"Char",MID(__Value,[Value],1)
)
RETURN
CONCATENATEX(__Table,[Char],,",")
In Table, "Name Again" column for Pam is "Pam".
In Table2, "Name Again" column for Pam is "PaM"
In Table3, "Name Again" column for Mike is "mike"
So, it is as if somehow CONCATENATEX is "remembering" the value of lower or upper case letter from a previous iteration?????
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.