Skip zero values in conversion or transformation file

[martin_novachig]

Hi colleagues,

I'm loading transactional data to BPC from a flat file,

My goal is NOT to load the lines that have zero balance,

I tested with the IF statement on the Mapping field of SignedData.

Also with a Conversion File of SignedData as show bellow

EXTERNAL  INTERNAL FORMULA

0                 *skip

0.0              *skip

0.00            *skip

0,000          *skip

but has not given me results

Thanks.

Regards,

Eng. Martin D. Novachig

[roslyn_rosalia3]

I know this is a very old post but this is what worked for me:

SKIPIF = 0.0000000

Our cube is defined as Large Signed Data which has seven decimal points.

[martin_novachig]

Hi Nilanjan,

I'm  loading a flat file with the 0 values but I have the same error,

Regards.

Eng. Martin D. Novachig

[Former Member]

Hi Martin,

You can use 'UJ_ROUTINE' BADI to call in your transformation file, there you can easily eliminate entries from the flat file who have signeddata value is '0'.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ;

SKIP = 0 START_ROUTINE = BADI_FILTER_NAME

Hope this may solves your problem.

Thanks,

Siva

[Former Member]

Hi Martin,

What is the error you are getting?

Unfortunately, I couldn't see any error message in your threads.

[martin_novachig]

Hi Nilanjan,

I'm working BPC 10 Microsoft Version. Not BADI again.

I'm loading transactional data to BPC from a flat file, My goal is NOT to load the lines that have zero balance. There isn't error but I can't resolve this issue. The zero values are loaded in BPC.....

Any suggestion?

Regards.

Eng. Martin D. Novachig

[Former Member]

Hi,

Have you tried to load the flat file with the 0 values?

[Former Member]

Hello Martin,

In your transformation file you have the following options available. Option "SKIPIF = NULL", skips the zero records:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ;

SKIP = 0

SKIPIF = NULL

Thank you

Best regards,

Raquel Oliveira

[martin_novachig]

Hi Raquel,

We continue with the same error,

Other response?

Regards,

Eng. Martin D. Novachig