Skip to main content
Member
Oct 1, 2024 9:11 PM UTC

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) 

Thank you,

Sharon

11 replies

Employee - Guide
Oct 1, 2024 9:33 PM UTC

A derivative rule may add a row.

sbuggleAuthor
Member
Oct 1, 2024 10:53 PM UTC

Ok will  check but do not think this is the case in our situation. Thanks

Employee - Guide
Oct 2, 2024 1:54 PM UTC

Is it a matrix data source (where you have two columns with values)? This would get split into two rows if so

sbuggleAuthor
Member
Oct 2, 2024 2:40 PM UTC

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. 

sbuggleAuthor
Member
Oct 2, 2024 6:46 PM UTC

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

OneStream Employee
Oct 21, 2024 10:27 AM UTC

I'm not sure if you are still having this issue or if you managed to resolve it.  If you want to work through the issue with someone, please do raise a ticket with the support team. Thanks

sbuggleAuthor
Member
Oct 21, 2024 12:32 PM UTC

Hello, 

We did get this resolved thank you.