Perform operation or modify fields on load

[#1]

Hi,

we wanted to know that can we perform operation on fileds while loading.

example:

suppose i have a table with 3 columns like

user:

user_id      user_name   user_salary

anjanemp_apt   anjan           20k

kumaremp_apt kumar          30k

and so on.

now i want to load user_id without "_apt"

like

user:

load purgechar(user_id,'_apt') as [user_id1],user_name.user_salary

from user

please advice,

thanks in advance.

[Anonymous]

Hi

In the script level use like this

Remove(user_id,'_apt','') as User_Id

[#3]

yes, after load we can do that,

But  wanted to do it at load itself , is that possible?

thanks

[marcus_sommer]

A transformation like Replace(user_id,'_apt','') as User_Id could be done directly within the first load.

- Marcus

[Anonymous]

Hi,

u can do it in the script level