topic Re: Formula help please! in App Development

Formula help please!

Bravo_B — Mon, 21 Dec 2020 23:08:24 GMT

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
Green	F, B
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!

Re: Formula help please!

MayilVahanan — Tue, 22 Dec 2020 02:51:53 GMT

HI @Bravo_B

Try like below

MapName:
Mapping LOAD * Inline
[
A1, A2
D, Dog
C, Cow
H, Horse
F, Fish
B, Bird
];

Temp:
LOAD *, Trim(SubField(Animal,',')) as A1 INLINE [
Colour, Animal
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;

Re: Formula help please!

RC_121985 — Tue, 22 Dec 2020 03:41:16 GMT

HI,

Do you have only 5 Vales or animals ?

D = Dog, C = Cow, H = Horse, F = Fish, B = Bird

or is there something apart from this ?

Re: Formula help please!

Bravo_B — Tue, 22 Dec 2020 04:16:07 GMT

Hi there,

Yes, only 5 animals. It is part of something bigger, but I am just trying to work out the formula for this kind of scenario.

Thanks!

Re: Formula help please!

RC_121985 — Thu, 14 Jan 2021 15:56:12 GMT

Hi ,

Could you please provide the result what you are expecting in other column.

Not sure i, completely understood the problem.

Thanks

Re: Formula help please!

Ksrinivasan — Thu, 14 Jan 2021 16:14:53 GMT

hi,

your formula will be like this

If (WildMatch([Animals],'D*'), 'Dog' ,'XX');

ksrinivasan

Re: Formula help please!

Ksrinivasan — Thu, 14 Jan 2021 16:25:26 GMT

hi,

If (WildMatch([Animal],'D*'), 'Dog' ,'XX');