topic New field creation using existing fields in QlikView

New field creation using existing fields

ranibosch — Thu, 02 Nov 2017 09:52:36 GMT

Hi,

I have a a table as follows:

No Transfer-from code Transfer-to code

TSHI047782 WRSS WRSH

TSHI047783 WRWH WRDI

etc.....

Basically I want to use the 'Transfer-from code" and then depending what the value in this field is, it should allocate it to a specific responsibility center.

So if the transfer-from code= WRSS,WRWH or WRDI

Then the responsibility center should be = WR

if the transfer-from code = MTWH or MTDI

Then the responsibility center should be = MT

The responsibility center is not available as a field in this table.

Re: New field creation using existing fields

Sergey_Shuklin — Thu, 02 Nov 2017 09:57:38 GMT

Hello!

Can you use Left() function for adding a new field?

Load *,

Left(Transfer-from code,2) as responsibility_center

from data_table;

And if you have the responsibility_center field in another table it will be concatenated with new created.

Re: New field creation using existing fields

srishsum2017 — Thu, 02 Nov 2017 09:58:41 GMT

please go through with

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/Left.htm

and other string functions

Re: New field creation using existing fields

antoniotiman — Thu, 02 Nov 2017 10:11:28 GMT

May be like this

LOAD *,Pick(Match([Transfer-from code],'WRSS','WRWH','WRDI','MTWH','MTDI'),'WR','WR','WR','MT','MT') as [responsibility center] Inline [
No, Transfer-from code, Transfer-to code
TSHI047782, WRSS, WRSH
TSHI047783, WRWH, WRDI
TSHI047784, WRDI, WRDI
TSHI047785, MTWH, WRDI
TSHI047786, MTDI, WRDI
];

Re: New field creation using existing fields

antoniotiman — Thu, 02 Nov 2017 10:16:37 GMT

or this

LOAD * Inline [
Transfer-from code,responsibility center
WRSS,WR
WRWH,WR
WRDI,WR
MTWH,MT
MTDI,MT];

LOAD * Inline [
No, Transfer-from code, Transfer-to code
TSHI047782, WRSS, WRSH
TSHI047783, WRWH, WRDI
TSHI047784, WRDI, WRDI
TSHI047785, MTWH, WRDI
TSHI047786, MTDI, WRDI
];