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 .
