Customer Portal

Loading Excel file with Header and Line Item detail

Comments 1

  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hi, regcider,

    You did not attach any Excel file (xls or xlsx), just csv files. So I will describe the procedure for a csv file.

    Basic idea is in adding some key joining item lines with their PO line. Then you can filter the input lines into two streams. I have noticed that you may filter the lines by the first character. Lines starting with "P" would be sent to another output than the others. And then you can join them using join key.

    I hope everything will be clear when you see the example attached here. csv_processing.zip

    Best regards,

Please sign in to leave a comment.