Discussion Board for collaboration related to QlikView App Development.
I'd work with wildmatch. Don't know the amount of cities you have, and how you'd like to combine them.
Below script generates a table City and another one Long. The 'nr' field will link both.
// the same order as on line 24, so Mumbai = 1, Kolkata = 2, etc...
(ooxml, embedded labels, table is City);
wildmatch(Field, '*Mumbai*', '*Kolkata*', '*Delhi*') as nr
(ooxml, embedded labels, table is [long field]);
Thanks Piet for your help.
I am getting error as 'MAPPING requires 2-column input '
Do I need to change anything if I am not using Inline table and fetching an excel mapping sheet.
Below is the script I am using.
Mapping LOAD *,
'@' & Destination & '@' ,
(ooxml, embedded labels, table is Sheet1)
// [Assigned To],
TextBetween(MapSubString('Mapping_Destination',[Website Enquiry Landing]),'@','@') as New_Destination ,
Add the following to the end of Breno Morais' (who did all the work) code:
LOAD Field, Concat(City, ', ') AS IncludedCities
WHERE Contains = 'Found'
GROUP BY Field;
Then create a TableBox with fields Field and IncludedCities.
Yes a mapping load has always two columns, say From and To. Load the city twice, once the City itself as the From column and once as '@' & City & '@' as the mapping To column
Thanks Piet, am able to achieve the result.