Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all
i have one table field which contain year 2014 and some integer values in it .
i.e.
Table
2014
1.2
2.3
2.4
1
3 and so on
i want to pick 2014 from it as a year and also want to add 2015 in it.
how can i do it.
output i need is
i.e.
Table
2014
2015
1.2
2.3
2.4
1
3 and so on
kindly help asap
If you need to add 2015 as valur for your field then:
Load * from table
concatenate
load * inline [
myfield
2015
];
let me know
Tbl:
Load * Inline [
Txt
2014
1.2
2.3
2.4
1
3 ];
Load Txt+1 As Txt Resident Tbl Where IsNum(Txt) And Len(Txt) = 4;