I want to load single column from table without excluding any column....
here I want to load Id column and value of id should be start with 'GN' only can anyone please tell me how is it
Load * resident myTable where Left(ID,2)='GN';
let me know
LOAD ID FROM yourtable
Where ID like 'GN*';
LOAD ID FROM table
Where ID like 'GN*'
Retrieving data ...