topic Re: Insert column - Script Qlikview in QlikView

Insert column - Script Qlikview

Thu, 13 Aug 2015 01:42:55 GMT

Hi,

How can I insert a column with values replacing one letter values in column 'PurcharseOrderTypeLine' :

Ex : P = Purchase

F = Force

S = Sale, ect....

Thx in advance

Re: Insert column - Script Qlikview

settu_periasamy — Thu, 13 Aug 2015 01:55:28 GMT

Hi,

May be try this..

Load YourFields,

if(PurcharseOrderTypeLine='P','Purchase',

if(PurcharseOrderTypeLine='F','Force',

if(PurcharseOrderTypeLine='S',Sale))) as PurcharseOrderTypeLine

Resident [YourtableName];

Re: Insert column - Script Qlikview

sunny_talwar — Thu, 13 Aug 2015 02:31:25 GMT

You can use a Mapping Load as it seems that you may have multiple PurchaseOrderTypeLine and doing it with if can be a hassle

MappingTable:

MAPPING

LOAD PurcharseOrderTypeLine,

Description

FROM Excel;

or you can do a Inline Load also

Fact:

LOAD allFields,

ApplyMap('MappingTable', PurcharseOrderTypeLine) as PurcharseOrderTypeLine1

FROM Source;

Re: Insert column - Script Qlikview

jagan — Thu, 13 Aug 2015 02:36:45 GMT

Hi,

Try like this

Load *,

if(PurcharseOrderTypeLine='P','Purchase',

if(PurcharseOrderTypeLine='F','Force',

if(PurcharseOrderTypeLine='S', 'Sale', 'N/A'))) as PurchaseOrderType

From DataSource;

OR the better way

Load *,

Pick(Match(PurcharseOrderTypeLine, 'P', 'F','S', '*'), 'Purchase','Force', 'Sale', 'N/A') AS PurchaseOrderType

From DataSource;

Efficient way:

LOAD

FROM DataSource;

Now create an Excel with below details

PurcharseOrderTypeLine, PurchaseOrderType

P, Purchase

F, Force

S, Sale

Now load this Excel file, this tables joins with the existing table based on PurcharseOrderTypeLine column, if in future there is any new value just add a new record in the Excel file.

Hope this helps you.

Regards,

Jagan.

Re: Insert column - Script Qlikview

qlikviewwizard — Thu, 13 Aug 2015 02:42:04 GMT

Hi ssaintlouis

Can you attach the sample file along with dummy data. It will help the folks to give quick solution. THanks.

Re: Insert column - Script Qlikview

Thu, 13 Aug 2015 14:55:20 GMT

Merci