Skip to Content
0
Former Member
Jan 06, 2012 at 04:03 PM

also, import empty rows

39 Views

Hi,

does anybody know how works the data import option: "also, import empty rows"?

I have an issue with it:

in a txt file where many lines havesame values on all dimensions but with different amounts, if the last line has an amount 0 and if the option is unchecked all these datas are not imported.

I'm on BFC 7.5 SP06.

here is the data file:

D_CA;D_DP;D_STADE;D_SEGMENT;D_SECTACT;D_AFF;D_PE;D_RU;D_AC;D_AU;D_CU;P_AMOUNT;D_FL;P_COMMENT

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-6275.85;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-70179.09;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-99.8;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-31336.43;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-10805.63;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;-1058.5;F99;

R;2011.12;COM;DINA;NA;ACOM;2011.12;XX;R707;0LIA01;EUR;0;F99;

If I clear the last line I import correctly all theses datas whatever the option.

thks a lot

Edited by: pachakuti on Jan 6, 2012 6:03 PM