Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD * INLINE [ ID, c1, c2, c3, c4, .... cn
1, - , yes, no, -, -, -
2, - , yes, no, -, -, -
3, - , no, no, -, -, -
4, - , -, -, -, -, -
];
I want to add a column flag at the end of the the table if ANY of the cells for a row have 'yes' in them. So in this case, an extra column would look as follows
1
1
0
0
try with
LOAD
*,
-1 * (MATCH('yes', c1, c2, c3, c4, cn) > 0) as flag
;
LOAD * INLINE [
ID, c1, c2, c3, c4, cn
1, - , yes, no, -, -, -
2, - , yes, no, -, -, -
3, - , no, no, -, -, -
4, - , -, -, -, -, -
];