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

Updating a record in a table in script - new to QlikView

Hi

I am new to QlikView and also new to SQL.

I have the following code which updates the 'debtor' table:

Inner join(debtor)

LOAD "s-order",

    upper ("sorder-category") as "sorder-category";

SQL SELECT "s-order",

    "sorder-category"

FROM PUB.sorder;

How do I now update one of the other fields in the 'debtor' table based on the results from this code above?

Thanks

2 Replies
Not applicable

Re: Updating a record in a table in script - new to QlikView

what do You mean "update one of the other fields in the 'debtor' table based on the results from this code above"

You can

drop field 'fieldname' from 'other table'

Inner join(debtor)

LOAD "s-order",

    upper ("sorder-category") as "sorder-category",

fieldname;

SQL SELECT "s-order",

    "sorder-category",

fieldname

FROM PUB.sorder;

Not applicable

Re: Updating a record in a table in script - new to QlikView

Hi

The other field is called SKU (product code). I want to change the contents in SKU field based on the sorder-category field.

eg - If ("sorder-category"="PRO", "Project", "SKU")

Can I just write this query after the last line in the code above?

Thanks for your help

Mark

Community Browser