topic Re: Can I change a record in a field during the Load process in QlikView

Can I change a record in a field during the Load process

Wed, 20 Nov 2013 10:38:13 GMT

Hi All,

I have a table which has a field called Forecast Version. The Forecast Version field contains three records which have the following name structure 'POR 2H13'. Is it possible to rename the recodr name during a load so that, for example, POR 2H13 becomes POR2H13?

Cheers,

John

Re: Can I change a record in a field during the Load process

jvitantonio — Wed, 20 Nov 2013 10:40:34 GMT

Hi,

You can use Purgechar(yourField, ' ')

BI Experience | A place to share our Business Intelligence experiences

Re: Can I change a record in a field during the Load process

swuehl — Wed, 20 Nov 2013 10:41:00 GMT

Yes, that should be possible, for example like

LOAD

if([Forecast Version] = 'POR 2H12','POR2H13', [Forecast Version]) as [ForecastVersion],

...

FROM ...;

LOAD

purgechar([Forecast Version], ' ') as [ForecastVersion],

...

FROM ..;

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 10:43:07 GMT

Hi John

if POR 2H13 is the field name then use

LOAD

"POR 2H13" as POR2H13

if POR 2H13 is the content then use

LOAD

trim(fieldname) as fieldname

best regards

chris

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 12:17:50 GMT

Hi Guys

My Load statement looks like this

FACTS:

Load

Data,

ForecastVersion,

Market,

Printer,

Measure,

Technology,

Geography,

ShipDate,

Date(Date# (ShipDate , 'YYYYMM'),'MMM-YY') as Date

VersionData:
LOAD Distinct
ForecastVersion
RESIDENT FACTS;

THe content of ForecastVersion is

Current

POR 1H13

POR 2H13

I wan t to cahnge this to (spaces removed) :

Current

POR1H13

POR2H13

The solution suggested does not work:

LOAD

"POR 2H13" as POR2H13

Qlikview sees this as a load from my source data. Can you help me in understanding how to incorporate the code into the script correctly please?

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 12:28:12 GMT

Hi ,

Use the code as below in the load statement .

PurgeChar(ForecastVersion,' ') as ForecastVersion

Regards

Yusuf

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 12:52:48 GMT

Hi John

this solution is for field name not for content

you must use

trim(ForecastVersion) as ForeCastVersion

or purgechar(ForeCastVersion,' ') as ForeCastVersion

best regards

chris

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 12:52:56 GMT

Hi ,

You can Use this code aslo in the load statement .

Replace(ForecastVersion,' ','') as [ForecastVersion]

here in bracket after FieldName 2 nd Paramater (' ') one space is there and 3 rd Paramater ('') no space is there.

Regards,

Ravikant.

Re: Can I change a record in a field during the Load process

Wed, 20 Nov 2013 13:29:10 GMT

HI All,

Thanks so much for the very helpful and quick replies. It's great to see that the solutions are simple and straightforward. I'm lerarning all the time