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

[Former Member]

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

[former_member186338]

Please select correct primary tag!

Looks like it's SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

[former_member186338 · Accepted solution]

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?frame...

Try:

SKIPIF = 2.1.1.0.2,NO_PRODUCT

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

[former_member186338 · Accepted solution]

And correct the primary tag - edit your question!

[Former Member · Accepted solution]

Looks like the link is incorrect....pointing it to Function reference EVDRE....

[former_member186338 · Accepted solution]

Updated the link!

[Former Member]

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

Thanks

[Former Member]

What was the solution? Please share...

[Former Member]

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

[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

[former_member186338]

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