Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can anyone help with this please??
Anyone on today that can help please?
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 residentStockMovementSales;
Concatenate
Load
[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;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 residentStockMovementSales;
Concatenate
Load
[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;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 residentStockMovementSales;
Concatenate
Load
[Stock Movement Reason Code], ReasonDescription,[Stock Adj Reason], [Stock Adj Reason] as Narrative Resident StoreReasonCode;