topic Re: Perform operation or modify fields on load in QlikView

Perform operation or modify fields on load

Thu, 22 Jan 2015 07:00:56 GMT

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"

user:

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

from user

please advice,

thanks in advance.

Anonymous — Thu, 22 Jan 2015 07:05:45 GMT

In the script level use like this

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

Thu, 22 Jan 2015 07:10:46 GMT

yes, after load we can do that,

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

thanks

marcus_sommer — Thu, 22 Jan 2015 11:36:01 GMT

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

- Marcus

Anonymous — Thu, 22 Jan 2015 11:40:39 GMT

Hi,

u can do it in the script level