How search each word from Input string in a column and display result to store in qvd ?
Hello Sirs ,
Even though i learnt function like subfield , but not gotting idea to use for below scenario .
let say i have a field called KEYWORD having value = TEST OF A DATA .
LOAD * INLINE [ KEYWORD TEST OF A DATA ];
I having another table
LOAD * INLINE [
ROLL, ASSIGNED_WORD, NAME 1, TEST RANK, JEEF 2, RANK, HENRY 3, DATA INTERVAL, BILL 4, TEST DATA OF SUBJECTS, KIRAN 6, MATHEMATICS, SAI 7, failed , LOCO 8, Remarks, TINA 9, Subject, JIM ];
ROLL
ASSIGNED_WORD
NAME
1
TEST RANK
JEEF
2
RANK
HENRY
3
DATA INTERVAL
BILL
4
TEST DATA OF SUBJECTS
KIRAN
6
MATHEMATICS
SAI
7
failed
LOCO
8
Remarks
TINA
9
Subject
JIM
10
A Mark
joe
What i now need is Take each word from KEYWORD of first table and compare it with values in column ASSIGNED_WORD of second table , if there is a match then 1 as result else 0 .
ROLL
ASSIGNED_WORD
NAME
SEG1
SEG2
SEG3
SEG4
SEG1 RESULT
SEG2 RESULT
SEG3 RESULT
SEG4 RESULT
1
TEST RANK
JEEF
TEST
OF
A
DATA
1
0
0
0
2
RANK
HENRY
TEST
OF
A
DATA
0
0
0
0
3
DATA INTERVAL
BILL
TEST
OF
A
DATA
0
0
0
1
4
TEST DATA OF SUBJECTS
KIRAN
TEST
OF
A
DATA
1
0
1
0
6
MATHEMATICS
SAI
TEST
OF
A
DATA
0
0
0
0
7
failed
LOCO
TEST
OF
A
DATA
0
0
0
0
8
Remarks
TINA
TEST
OF
A
DATA
0
0
0
0
9
Subject
JIM
TEST
OF
A
DATA
0
0
0
0
10
A Mark
joe
TEST
OF
A
DATA
0
0
1
0
KEYWORD value can be anything . And hence above table structure should be dynamic and stored in qvd .
Test: Load *, if(exists(KEYWORD,ASSIGNED_WORD),1,0) as flag;
LOAD * INLINE [
ROLL, ASSIGNED_WORD, NAME 1, TEST RANK, JEEF 2, RANK, HENRY 3, DATA INTERVAL, BILL 4, TEST DATA OF SUBJECTS, KIRAN 6, MATHEMATICS, SAI 7, failed , LOCO 8, Remarks, TINA 9, Subject, JIM ];
I just changed the keyword to check the flag column also attached the sample please check
