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