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

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.

Input

Accepted answers

WilliamR

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).

All comments

WilliamR

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 🙂

EmilyL

Hi William, can you explain how do are you even able to see the back end coding?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703