Forum Discussion

sbuggle's avatar
sbuggle
New Contributor II
11 months ago

Importing excel file adds 2 rows per RP

Hi OneStream Community,  Does anyone know why an import would add two rows in the load step with an excel import? In the import processing log shows only 1 line read but it adds 2 rows. (edited)  Th...
Import
sbuggle's avatar
sbuggle
New Contributor II
11 months ago

This is not the case on this import.  Do you know of any other reason this could be happening.  We are going to create a new excel file. 

sbuggle's avatar
sbuggle
New Contributor II
11 months ago

There are three text values that are being sent to the TextValue .

  • KarlT's avatar
    KarlT
    Icon for OneStream Employee rankOneStream Employee
    11 months ago

    I would think these three value are simply being concatenated on your import under Text Value if i'm understanding your setup.

    I personally cant think of any other obvious reason this would happen beyond derivative rules or matrix load. Are the two lines of data identical? what kind of data import are you using (delimited, fixed, connector, excel)?

    • sbuggle's avatar
      sbuggle
      New Contributor II
      11 months ago

      This data import is excel. 

      • KarlT's avatar
        KarlT
        Icon for OneStream Employee rankOneStream Employee
        11 months ago

        In which case maybe double check the file to make sure there isn't any hidden rows/columns etc. i think if not you may want to reach out to OS support so you can share screens and look at the specific files.