Forum Discussion

psatkar's avatar
psatkar
New Contributor
2 years ago

how to delimite headers while uploading file

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

 

Transformation
  • JackLacava's avatar
    JackLacava
    2 years ago

    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.
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    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.