Is there away to change the value of a colum in a table if another column has a different value?
Lets say I want all records where column 3 equals 6010 to have column 1 values be changed to 1000. How would I do that and have it fit with eveything else in my document?
Try like this in script
Load *, if(Column3 = 6010, 1000,Column1) as Column1 from tablename;
Hope it helps
Retrieving data ...