topic Re: Create field challenge in QlikView

Create field challenge

Wed, 25 Nov 2020 16:16:04 GMT

Hi all, I have an excel contains two fields, wanna create a new field when loading it into qlikview like the one shown at the below, i have thought about looping and subfield, but still fail after a couple of try. Any ideas? Thanks

Re: Create field challenge

arulsettu — Mon, 25 Jul 2016 07:10:35 GMT

try this

Replace(Center,',','|')

Re: Create field challenge

antoniotiman — Mon, 25 Jul 2016 07:15:24 GMT

Try

LOAD
SubField(City,',')&'|'&SubField(Center,',') as Key
Inline [
City,Center
'A,B','aa,bb'
'C,D','cc,yy'
'E,F','dd,zz'
];

Re: Create field challenge

PrashantSangle — Mon, 25 Jul 2016 07:15:36 GMT

Hi,

I am not sure what are you looking for

try this

LOAD subfield(City,',') &'|'& subfield(Center,',') as key

FROM

[key test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards

Re: Create field challenge

Mon, 25 Jul 2016 07:15:54 GMT

Hope, its too simple, no need looping, just SubField(City, ',')&'|'&SubField(Center, ',') as key

Re: Create field challenge

Mon, 25 Jul 2016 07:17:57 GMT

If you want to use subfield, you can try this:

Test:

Load *, City & '|' & Center as key ;

Load

Subfield(Center,',') as Center,

Subfield(City,',') as City

FROM

[.\key test.xlsx]

(ooxml, embedded labels, table is Sheet1);