This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
LOAD SubField(City,',')&'|'&SubField(Center,',') as Key Inline [ City,Center 'A,B','aa,bb' 'C,D','cc,yy' 'E,F','dd,zz' ];
I am not sure what are you looking for
LOAD subfield(City,',') &'|'& subfield(Center,',') as key
(ooxml, embedded labels, table is Sheet1);
Hope, its too simple, no need looping, just SubField(City, ',')&'|'&SubField(Center, ',') as key
If you want to use subfield, you can try this:
Load *, City & '|' & Center as key ;
Subfield(Center,',') as Center,
Subfield(City,',') as City