topic Merging 2 fields together in QlikView

Merging 2 fields together

hopkinsc — Fri, 26 Nov 2010 12:37:01 GMT

Hi, i am trying to merge 2 fields together. and call it [Stock Movement Reason]

the fields are:

ModifiedNarrative
[Stock Adj Reason].

An example of the data within each field is

ModifiedNarrative
STK Ordering
STK Goods Received
STK Adjustment

Stock Adj Reason
P/O Manual
P/O Picco
Waste Manual
Waste Picco

I want to combine them to make one list
STK Ordering
STK Goods Received
STK Adjustment
P/O Manual
P/O Picco
Waste Manual
Waste Picco

Can anyone help me to do this please?
Thanks very much

Merging 2 fields together

hopkinsc — Fri, 26 Nov 2010 13:10:08 GMT

Any help on this?

Merging 2 fields together

Fri, 26 Nov 2010 13:16:27 GMT

Hi ,

It can be done through Concatenate option.

Please refer the attached file.

Merging 2 fields together

hopkinsc — Fri, 26 Nov 2010 13:35:22 GMT

Hi, thanks for your reply,

Here is my script.

LOAD StoreNumber,
StoreDate,
[Stock Movement Reason Code],
// ProductCode,
EANCode AS EAN,
// IssueNumber,
// CommodityGroup,
EmployeeId,
Narrative AS ReasonDescription,
StockQty,
StockValue,
LinesAffected,
CostValueDiff,
RSPValueDiff,
StoreTime,
%LkStoreReasonCode,
if(wildmatch(Narrative,'Goods*')>0,'GRN (Completed)',
if(wildmatch(Narrative,'Stock*')>0,'STKVAR Stock Checking',
if(wildmatch(Narrative,'Ordering*')>0,'STKADJ Ordering Screen',
if(wildmatch(Narrative,'Order Main*')>0,'STKADJ Order Maintenance')))) as ModifiedNarrative

FROM $(cFileName) (qvd);

ENDIF

SET cFileName = $(RetailPath)StoreReasonCode.qvd;
IF QvdCreateTime('$(cFileName)') >= 0 THEN

StoreReasonCode:
Join LOAD [Stock Movement Reason Code],
ReasonDescription,
ReasonDescription & ' - ' & [Stock Movement Reason Code] AS [Stock Adj Reason]

FROM $(cFileName) (qvd);

The ModifiedNarrative is on the last line of the 1st table and Stock Adj Reason is the last field of the 2nd table.

How would i write this into the script please?

Merging 2 fields together

Fri, 26 Nov 2010 13:48:09 GMT

Can you please share your QVW file.....

Also you can refer the concatenate section in the reference manual.

Merging 2 fields together

prieper — Sat, 27 Nov 2010 09:29:11 GMT

Within your scipt you merge two table with JOIN-command on one keyfield.
Further calculations (like the required concatenation) have then to be done by creating a new table.

Table1: LOAD Key, Field1.... FROM ....;
JOIN (Table1) LOAD Key, Field2 .... FROM ....;
NewTable: LOAD Field1&Field2, ... RESIDENT Table1;
DROP TABLE Table1;

HTH
Peter

Merging 2 fields together

hopkinsc — Mon, 29 Nov 2010 10:20:33 GMT

Hi Peter, thanks for your reply.

Is there any chance you could post a sample of what you mean, I have tried doing what you have said but it keeps failing...

Merging 2 fields together

hopkinsc — Mon, 29 Nov 2010 12:11:34 GMT

Does anyone have an example of this please??

Merging 2 fields together

Mon, 29 Nov 2010 13:56:33 GMT

Can you please share your QVW file...............

Merging 2 fields together

hopkinsc — Mon, 29 Nov 2010 14:08:58 GMT

Hi XXX, Thanks for your reply.

Attached is my QVW.

In the load script i want to join together:

TABLE: storestockmovement (This has a join to another table and is called 'StockMovementSales')

FIELD: Narrative

and

TABLE: StoreReasonCode

FIELD: [Stk Adj Reason] (Which is a renamed field. If this can't be done then instead of [Stk Adj Reason], use ReasonDescription

and i would like to call the joined field 'Adj Reason'

Thanks

Merging 2 fields together

hopkinsc — Mon, 29 Nov 2010 17:06:53 GMT

Can anyone help with this please??

Merging 2 fields together

hopkinsc — Tue, 30 Nov 2010 12:51:34 GMT

Anyone on today that can help please?

Merging 2 fields together

Tue, 30 Nov 2010 13:21:03 GMT

Hi hopkinsc,

I am not able to run the code using ur QVW file since there is no datasource but still u can run the code and check .It will create one more table with similar StoreReasonCode with one additinoal column.

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;

Merging 2 fields together

Tue, 30 Nov 2010 13:21:07 GMT

Hi hopkinsc,

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;

Merging 2 fields together

Tue, 30 Nov 2010 13:21:10 GMT

Hi hopkinsc,

StoreReasonCode1:

Load

Narrative resident

StockMovementSales;

Concatenate

Load

[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;