Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!!
is it possible to make another column by adding or subtracting other two columns?
for example, let's say by Outer Joining I got three columns col1, col2, col3
Can I make col4 by col1 - col2?
NewTable:
LOAD
col1, col2, col1 - col2 as col3
RESIDENT
OldTable;
DROP TABLE OldTable;
NewTable:
LOAD
col1, col2, col1 - col2 as col3
RESIDENT
OldTable;
DROP TABLE OldTable;