Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Help needed in Load script

Hi

I am getting field not found error in my script. My script looks like this:

LOAD

    *,

if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

;

Stockvalue:

LOAD

     art_id as [Article Id],

     attr2_id,

     qty as [Quantity in stock],

     price as [Stock price],

     rate

FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

;

Now, when I reload, I get field not found <Article Id>. Can anyone help me, what am I doing wrong here? Please!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Help needed in Load script

hi Try this

Stockvalue:


LOAD

    *,

if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

;

LOAD

     art_id as [Article Id],

     attr2_id,

     qty as [Quantity in stock],

     price as [Stock price],

     rate

FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

;

Regards

Sravan

6 Replies
Not applicable

Help needed in Load script

Try this:

Stockvalue:

LOAD

     art_id as [Article Id],

     attr2_id,

     qty as [Quantity in stock],

     price as [Stock price],

     rate

FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

;

LOAD

    *,

if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

Resident Stockvalue;

Not applicable

Help needed in Load script

Hi,

thanks for the reply. But now I get error message, "Table not found Stockvalue ".

Not applicable

Help needed in Load script

hi Try this

Stockvalue:


LOAD

    *,

if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

;

LOAD

     art_id as [Article Id],

     attr2_id,

     qty as [Quantity in stock],

     price as [Stock price],

     rate

FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

;

Regards

Sravan

Not applicable

Help needed in Load script

Hi Sravan,

Thank you. It worked! Even when I removed the alias "Stockvalue". But why doesn't the top load statement work when I put it at the  top of the tab that contains this script? Anyone?

Best regards,

Not applicable

Re: Help needed in Load script

Stockvalue:

// Step2: Here Qlikview understands the field [Article Id] rather than art_id because it is already loaded  in before Load as [Article Id].


LOAD

    *,

if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

;

//Step1: Here the art_id is loaded as [Article Id]. Qlikview does know only art_id at this moment.

LOAD

     art_id as [Article Id],

     attr2_id,

     qty as [Quantity in stock],

     price as [Stock price],

     rate

FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

;

Not applicable

Re: Help needed in Load script

Dear Syed,

If it solved please click as solved so that other users may benefit.

if you still dont understand you can ask questions!

Community Browser