Forum Discussion

mithsrini's avatar
mithsrini
New Contributor II
6 years ago

Head/Tail snap dynamically setting Offset value

Hello, I am working on loading data from big excel file into a database. I want to use Head/Tail snaps to dynamically take “Documents offset*” from upstream. Please suggest if there is an alternat...
head
pipeline
tail
koryknick's avatar
koryknick
Employee
6 years ago

Did you look at the Excel Parser “Start row” and “End row” properties?

  • mithsrini's avatar
    mithsrini
    New Contributor II
    6 years ago

    Sure I will try that. Thanks for quick response.

    Thanks,

    Mithila

  • mithsrini's avatar
    mithsrini
    New Contributor II
    6 years ago

    But this is effective and calling all the records in the excel file. Basically how to repeatedly call all the rows by looping? I want to chunk the data load, but need to read all the data.