FORMULA error

[Former Member]

Guys I am trying to SKIP a few Materials in my DATA LOAD. And I am using the following formula

IF( MATERIAL = "ABC", SKIP_RECORD( ), MATERIAL )

but I keep getting error "Formula element is not allowed here"

What am I doing wrong???

I need to SKIP a few Materials. If you want to suggest that I write a START or TRANSFER ROUTINE, could you please give me the exact formula Please...

Much appreciated

[Former Member · Accepted solution]

Right form must be...

IF( MATERIAL = 'ABC' OR MATERIAL = 'BDC', SKIP_RECORD( ), MATERIAL )

You could have many ORs but always with "MATERIAL ="

Regards

Message was edited by:

Oscar Díaz

[Former Member · Accepted solution]

Hello

I am also stuck in similar error. I have to fill partcular field (salesgroup ) with value A1 if material is ABC other wise skip record using the syntax here in the update rule (formula fumction) I am getting an error

any tips?

Thx

Praveen

[Former Member]

Try do that in normal mode....i try to do yoru routine in normal mode and next change to expert mode and the formula changes automathically to:

IF( MATERIAL = 'ABC', SKIP_RECORD( ), MATERIAL )

Try this....

[Former Member]

It works

That is INSANE..... I could not believe that.. Thanks a lot Oscar.

I also would like to know how would I do it for say about 50 odd materials, should I keep adding OR and the Materials. Will that be the right approach.

IF( MATERIAL = 'ABC' OR 'BCD', SKIP_RECORD( ), MATERIAL )

Thanks dude,

[Former Member]

which version are you on..?

write this in start routine..

DELETE DATA_PACKAGE WHERE MATERIAL EQ 'ABC'.

[Former Member]

Hi Ragini,

When you say delete data Package would it be deleting the whole package or just that MATERIAL. As I donot want any other Material deleted.

Also, where EXACTLY do I enter this formula in the Start Routine.

Thanks a lot for your help

[Former Member]

records pertaining to only that material mentioned in where clause.

[Former Member]

Are you using expert mode?

[Former Member]

Yes Oscar,

I am in expert mode.