Fixed Length File SFTP Import

Lisa Callahan
Lisa Callahan Member, Infor Partner Posts: 11
in Birst

I have a 100 byte fixed length txt file that I need to SFTP into Birst. There are no headers in the file. When I add it to do a quick upload as a test, I receive an error that I need at least two columns to import.

image.png
image.png

I was hoping I could import the file as is (with one column) and then parse it later in Prepare.

I am totally new to the whole SFTP thing so any advice (and or different approaches) would be greatly appreciated!

Thank you,

Lisa

Answers

  • Enrico Menotti
    Enrico Menotti Member Posts: 50

    Hi Lisa,

    To me this looks like a known behavior - whenever I have uploaded a file by drag&drop, Birst has always required

    1. A header line
    2. At least two columns

    Best,

    Enrico

Categories