Discussion Board for collaboration related to Creating Analytics for QlikView.
Lets say I have 2 cols, I want to see if any word in col2 appear in col1? If a word matches in both then flag it etc.
Go to Solution.
//--- original table
LOAD * Inline [
id, t1, t2
1, John Hello, Max Bye John
2, Frank, Piter
//--- separate first col by words
SubField(t1,' ') as s1
//--- separate second col by words
SubField(t2,' ') as s2
//--- find out the same words
Inner Join (t2)
id, s2 as s1
DROP Table t3;
//--- if col1 and col2 have more then 1 same word - leave only one id per row
1 as flag
DROP table t2;
//--- add flag to original table
Left Join (t1)
Find the attached application and let me know whether this is what you want.
Not really I'm afraid. Both cols contain a number of words within a text string, if it was single chars or single words in both that would be fairly easy to do. Thanks though!
Used the Subfield method and then marked each record as Y/N match. Thanks.!