Skip to Content
0
Former Member
Jan 23, 2009 at 12:46 AM

SKIP blank record

43 Views

Hi,

Is there a way we can skip records with blank values while loading data into BPC. I have a data extract in which some dimension values are blank and it's a requirement to skip these records.

In the conversion file I tried this formula, basically if the length is zero then SKIP the record. Doesn't work

EXTERNAL INTERNAL

  • If(vb:len("%external%")=0 then *SKIP;%external%)

thanks in advance