Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify data in the script

Hi,

I have a file qvw your database a xml file. I need to modify some data in some fields, eg the field MANAGER presents the data as follows: 132; # Name Manager. I need to be displayed only the name follows: name manager (without previous code). Thank you all for your help.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

I used some functions character and was as follows:

LOAD

          Mid(ows_Field, NumSum(Index(ows_Field, '#', 1), 1)) as 'Field',

Thank's Jason for help.

View solution in original post

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Try:

LOAD

     Field1,

     Field2,

     Field3,

     SubField(MANAGER,'# ',2)     AS     MANAGER,

     Field4,

     etc

From.....;

Hope this helps,

Jason

Not applicable
Author

Hi,

I used some functions character and was as follows:

LOAD

          Mid(ows_Field, NumSum(Index(ows_Field, '#', 1), 1)) as 'Field',

Thank's Jason for help.