Skip to Content
avatar image
Former Member

Changing names of table input

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 19, 2013 at 02:26 PM

    Hi Jan,

    Can you please elaborate a little bit?

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

    Thanks,

    Talia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ehud Nir

      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

  • Mar 20, 2013 at 07:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded