Skip to Content
avatar image
Former Member

How to skip specific row from data file if certain member combination is matched.

Dear All,

I want to upload one transaction data flat file ,where I want to skip certain number of rows if some specific member combination are match.example skipp-tr-data.png.In transformation I try to use SKIPIF options but it not use.

Appreciate any one input.

Thanks

Mayuri

skipp-tr-data.png (12.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 07, 2016 at 12:08 PM

    Flat file has to be presented in notepad to see delimiters etc... Is it comma delimited?

    Format of SKIPIF is incorrect, read:

    http://help.sap.com/saphelp_bpc75_nw/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm?frameset=/en/81/94a8a5febd40268d5c59b4fc31be37/frameset.htm¤t_toc=/en/66/348113c47b4ae7b2f068b88047d02b/plain.htm&node_id=142&show_children=false

    Try:

    SKIPIF = 2.1.1.0.2,NO_PRODUCT

    "|" is used to separate different string, not columns...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2016 at 09:13 AM

    Please describe the condition to skip in details, not by simply highlighting lines.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2016 at 09:39 AM

    cube-data.pngtransformation-file.pngflat-file.png

    Thanks vadim for your quick answer ,I write the condition in transformation file in options SKIPIF section <ACCOUNT | NO_PRODUCT> ,when I validate the transformation file it shown validate corectly and number of skip record is 4,but when I check it to in BW it shown data.validation-status.png.

    Thanks

    Mayuri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      First delete the data in the cube and then try again loading.....Is the no. of records skipped as per the condition? 2.1.1.0.2 & NO_PRODUCT? Also keep the Time column format as "Text" to avoid the excel corrections of decimal for .10 to .1 for 2016.10!

      JP

  • avatar image
    Former Member
    Dec 07, 2016 at 12:41 PM

    Yes Vadim now it's load the data correctly,Thanks for your help next time I keep in mind for primary tag.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded