topic Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names in QlikView

I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

Wed, 25 Nov 2020 16:16:04 GMT

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

Anil_Babu_Samineni — Fri, 16 Jun 2017 16:44:01 GMT

What are the sult and Re in your values? Where this data coming from. Would you explain little more

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

tajmohamed30 — Fri, 16 Jun 2017 16:51:04 GMT

hi Harasawa,

give a try at the below link

Replace function: Find Multiple strings and replace to blank

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

vishsaggi — Fri, 16 Jun 2017 16:52:02 GMT

Try these in your Load script where you getting those field names

LOAD ....,

IF(NOT Match(Year, 'sult'), Year) AS NewYear,

IF(NOT Match(MonthNames, 're'), MonthNames) AS Month

FROM yousource;

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

Fri, 16 Jun 2017 17:10:15 GMT

I believe it is from this. This is at the very end but has no values

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

vishsaggi — Fri, 16 Jun 2017 17:17:37 GMT

Can you share your actual script for those fieldnames?

Re: I'm trying to get ride of the "sult" and "re" also trying to make the month numbers in actual names

Anonymous — Fri, 16 Jun 2017 20:15:35 GMT

You'll want to remove those records from your data. I'm guessing besides your month and year filters you have an extra 'results' row that doesn't belong.

In your script you'll want to add a where clause to remove it.

Something like

Load *

From YourFile

where not wildmatch(Month,'Res')

;