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.
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 number
remove blanks in that array
loop
voila done
pls help convert into query
Input | Input | Output |
Hi I am having issue with this product | product issue having | having issue with product |
Error product live Monday dumm | product error Monday live | error product live Monday |
defective product hello dummy | dummy hello product defective | defective product hello dummy |
issue report | report issue | issue report |
I am having trouble | trouble having am | am having trouble |
Solved! Go to Solution.
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"
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.