Skip to Content
avatar image
Former Member

BPC 10 – HOW TO UPLOAD A FLAT FILE WITH EMPTY FIELD(s)

Hello Experts,

I’m trying to upload a flat file with transactional data and I would like to map those empty fields to specifics members ID.

See an example below (imagine that I cannot change the source file)

ACCOUNT ENTITY TIME CATEGORY SIGNEDDATA ACC1 USA1 2018.JAN 50 ACC2 USA2 2018.JAN BUDGET 100

In the first line, the field “Category” is empty so in those case I would like to map the External value “empty” to “ACTUALS”. Is this possible in the conversion file?

I tried:

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = COMMA SKIP = SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT=-1 ROUNDAMOUNT= *MAPPING ENTITY=*COL(2) ACCOUNT = *COL(1) TIME= *COL(3) CATEGORY = *COL(4) AMOUNT = *COL(5) *CONVERSION CATEGORY=CONVERSION.XLS!CATEGORY

And in the conversion:

EXTERNAL INTERNAL FORMULA ? ACTUALS ACTUALS <empty> ACTUALS

And didn’t work.

Do you have any suggestion?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 10, 2017 at 02:12 PM

    I see some other strange things - DELIMITER=COMMA

    Has to be

    DELIMITER=,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 09, 2017 at 06:46 PM

    In mapping section use IF. Not in conversion !

    And please remove incorrect tag - you are using BPC NW or MS ??????

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2017 at 12:14 PM

    Try

    CATEGORY=*IF(*col(4) = *STR() THEN *STR(ACTUALS);*col(4))

    Add comment
    10|10000 characters needed characters exceeded