Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sorting text second col in accordance with first column

  demo data  for required output logic in java for each row store each word with a sequenced array String compare word in second col row1 with array  if matches put that word at the position ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test (later on when you use the query on your dataset, you will have to change the source appropriately)

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TY9LDsMgDESvYrHONSq1i54AZUGDWyxBHBlIlds3/KqsGDHvoUFrdSd4gAngzE7rByjGjPCl5CA5irAJ27wkNameOtFwNU9a3URYBgiedoQnr9YcYHMIFxMr2LvCVd3iG5dUrME59J6rfJx2PfvdIP5OfaEtEtxYytAW2s7aX/+XhPPL44n1NAoT1Dz/AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Combine(List.Select(Text.Split([Column1]," "),(x)=>List.Contains(Text.Split([Column2]," "),x,Comparer.OrdinalIgnoreCase))," "))
in
    #"Added Custom"
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test (later on when you use the query on your dataset, you will have to change the source appropriately)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TY9LDsMgDESvYrHONSq1i54AZUGDWyxBHBlIlds3/KqsGDHvoUFrdSd4gAngzE7rByjGjPCl5CA5irAJ27wkNameOtFwNU9a3URYBgiedoQnr9YcYHMIFxMr2LvCVd3iG5dUrME59J6rfJx2PfvdIP5OfaEtEtxYytAW2s7aX/+XhPPL44n1NAoT1Dz/AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Combine(List.Select(Text.Split([Column1]," "),(x)=>List.Contains(Text.Split([Column2]," "),x,Comparer.OrdinalIgnoreCase))," "))
in
    #"Added Custom"