Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi Brains Trust,
I wonder if you can please help me with my formula. The formula in a field I have created is to find the letter D in one of the other columns in the set. In the new field put the word 'Dog' and for all other letters/numbers that appear, put an 'X'.
If (WildMatch([Animals]'D*')=1, 'Dog' [,else 'X'])
Please see the table below;
D = Dog, C = Cow, H = Horse, F = Fish, B = Bird
|Colour||Animal||Results (Formula above)|
|Brown||D, C, H|
|Black||D, C, H, F, B|
I have tried this formula but is still saying there is an error, can anyone shed some light on where I'm going wrong or what I could try?
Thanks in Advance!
Try like below
Mapping LOAD * Inline
LOAD *, Trim(SubField(Animal,',')) as A1 INLINE [
Brown, "D, C, H"
Green, "F, B"
Black, "D, C, H, F, B"
Load Colour, Concat(ApplyMap('MapName', A1, 'X'),',') as Animal Resident Temp group by Colour;
DROP Table Temp;