Changing "Start Data Import on Line" on several Import Data tools at once

[slobodan]

Hello,

I have 40 input files in 40 Input data tools in the workflow. 

For each Input data tool I want to change Start Data Import on Line value from 1 to 6 at once.

I tried to select several Input Data tools and changed value from 1 to 6 but it didn't work. So is there a way for a change multiple Input Data tools at once?

Thank you. 

[WilliamR · Accepted solution]

Hi @slobodan ,

you can edit your workflow in a notepad, and look for this tag:  <ImportLine>5</ImportLine>

and modify with a Find and Replace with the desired value.

(Backup your workflow prior to do this modification to test it).

(If this post helps, then please consider it as the solution to help the other members find it more quickly).

[huynv96]

The rows you want to ignore has unuse data or completely empty?

If they completely empty, you can filter null end take field name from first row to header by Dynamic rename tool

[David_Doyle]

Thanks @WilliamR!! For some reason the "start data import on line" feature rarely works but I followed your instructions and it worked like a champ!  Thank you! Almost a year later and still adding value 🙂