Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Replace(Center,',','|')
Try
LOAD
SubField(City,',')&'|'&SubField(Center,',') as Key
Inline [
City,Center
'A,B','aa,bb'
'C,D','cc,yy'
'E,F','dd,zz'
];
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
Hope, its too simple, no need looping, just SubField(City, ',')&'|'&SubField(Center, ',') as key
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);