Changing names of table input

[Former Member]

Hi all,

In our system we have tasks with various names and I wish to group similar ones together.

I would like to have

1) Vendor Modify & Vendor Create to become just 'Vendor'

2) Create Material & Modify Material to become just 'Material'

I have tried via the 'REPLACE' fuction but I only succeed in putting in one REPLACE function.

Can someone help me here?

Thanks,

Jan

[talia_gurevich · Accepted solution]

Hi Jan,

Can you please elaborate a little bit?

May be screenshot of the model will help to understand the question...

Thanks,

Talia

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Talia (and others),

In the screenshot below I have grouped on process title to visualize my problem a little bit better. So as you can see there are for the moment 4 main process titles. 2 which have 'Material External Procurement' in its name and 2 having "Vendor" in the process name.

What I would like to have now is to group together all processes that have 'vendor' in it as one and all processes having 'material external procurement' in it as one. So basically instead of 4 main process titles, 2. This so that I can afterwards make a nice pie chart on how many processes actually concern vendor or material.  But I would like to keep this in one table, so not creating 2 different tables and then filter the tables, one for vendor and one for materials.

I hope this clarifies my issue .

Thanks,

Jan

[former_member202465 · Accepted solution]

Hi Jan,

I hope I understand correctly. You wish to have something like this, where the text showing is of field txt1 but you could group by txt2 that takes part of txt1 name:

If this is the case I suggest to add another fiels, in this exampel txt2. Its value property is taken from txt1 in the following manner for example:

=IF(CONTAINS(@TXT1,"vendor"),"vendor",

   IF(CONTAINS(@TXT1,"material"),"material",@TXT1))

Using the IF statement:

IF(condition, expression if true, expression if false).

Hope it helpes,

Thanks,

Udi

[Former Member · Accepted solution]

Thanks Udi,

This was exactly what I was looking for!

I was just not aware on how to combine the IF-function with several CONTAINS-functions. Now that I see your solution/example, it is very clear to me.

Kind regards,

Jan

[swapnil_shelke]

Hi,

I think you must create the new table with normalized form or can create the view with two table specified above.

1) Vendor Modify & Vendor Create to become just 'Vendor'---> Create the single view with name 'Vendor'

2) Create Material & Modify Material to become just 'Material' ---> Create the single view with name 'Materail'

If you can provide the more details then I could help with explanation.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

What information do you require for this?

Thanks,

Jan

[swapnil_shelke]

Nothing, I got, it is differnet than what I supposed.