topic Re: Add new fields in App Development

Add new fields

Anonymous — Thu, 13 Dec 2018 03:05:58 GMT

IF(WILDMATCH([Model],'*GTR-X 230*'), ' Playful' ) as [Riding Style]

The expression above states if the [Model] field contains ‘*GTR-X 230*’ then create a new field named [Riding Style] with the contents ‘Playful’

I want to modify it so that if the [Model] field contains ‘*GTR-X 230*’ then create 6 new fields named

[Riding Style] with contents ‘Playful’

[Seating] with contents ‘1’

[Riding Time] with contents ‘Short’

[Water Type] with contents ‘Mostly Flat’

[Speed] with contents ‘Very’

[Two Sports] with contents ‘Rarely’

Can you help?

Re: Add new fields

lblumenfeld — Thu, 13 Dec 2018 05:19:59 GMT

You could simply repeat the WildMatch statement for each field. What do you want to do when the [Model] field doesn't contain ‘*GTR-X 230*’? That would help us answer the question.

Re: Add new fields

Anonymous — Thu, 13 Dec 2018 17:14:21 GMT

Can someone help, I want to consolidate 6 separate expressions into one?

IF(WILDMATCH([Model],'*GTR-X 230*'), ' Playful' ) as [Riding Style]

The expression above states if the [Model] field contains ‘*GTR-X 230*’ then create a new field named [Riding Style] with the contents ‘Playful’

I want to modify it so that if the [Model] field contains ‘*GTR-X 230*’ then create 6 new fields named

[Riding Style] with contents ‘Playful’

[Seating] with contents ‘1’

[Riding Time] with contents ‘Short’

[Water Type] with contents ‘Mostly Flat’

[Speed] with contents ‘Very’

[Two Sports] with contents ‘Rarely’

Re: Add new fields

lblumenfeld — Thu, 13 Dec 2018 18:08:56 GMT

If the model is not ‘*GTR-X 230*’ then what do you want to do. In other words, do you load this data only for that wildmatch, otherwise you don't load it, or do you only load some (other) fields, or those fields with another value? This will determine what your load statement needs to look like.