This is a sample table and I would like to update the column ‘TYPE’ as like the value which is there ‘STOCKIN’ /’STOCKOUT’ for the particular DOCNUM in each row.
Sample Table
CODE | DOCNUM | TYPE |
---|---|---|
Z01 | NUM12 | stockin |
Z01 | NUM12 | null |
Z01 | NUM12 | null |
Z01 | NUM12 | null |
Z01 | NUM134 | stockout |
Z01 | NUM134 | null |
Z01 | NUM134 | null |
Z01 | NUM134 | null |
Expected table
CODE | DOCNUM | TYPE |
---|---|---|
Z01 | NUM12 | stockin |
Z01 | NUM12 | stockin |
Z01 | NUM12 | stockin |
Z01 | NUM12 | stockin |
Z01 | NUM134 | stockout |
Z01 | NUM134 | stockout |
Z01 | NUM134 | stockout |
Z01 | NUM134 | stockout |
Please help me how can I update the column Type for each row as per the DOCNUM.
You need to sign in to view this answers
Leave feedback about this