Skip to main content
Newcomer
February 23, 2023
Solved

how to delimite headers while uploading file

  • February 23, 2023
  • 1 reply
  • 0 views

I am trying uploading a .csv file but i am getting transformation errors. In the source file the 3 rows are blank. How should I set the criteria value text anywhere within a line that triggers the lines to be bypass

 

Best answer by JackLacava

I'm not sure I follow, your title and post are talking about different things... For the record, OneStream automatically skips any rows not containing numbers in the position where the Amount value is expected.

You might want to post a few screenshots, for example:

  • The actual error
  • Shape of your file (anonymize values)
  • If your Import step fails completely, the Last File Log that you can get with the little gear icon in the Import screen.

1 reply

OneStream Employee
February 24, 2023

I'm not sure I follow, your title and post are talking about different things... For the record, OneStream automatically skips any rows not containing numbers in the position where the Amount value is expected.

You might want to post a few screenshots, for example:

  • The actual error
  • Shape of your file (anonymize values)
  • If your Import step fails completely, the Last File Log that you can get with the little gear icon in the Import screen.