Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

slobodan
5 - Atom

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. 

 

slobodan_0-1577029322994.png

3 REPLIES 3
WilliamR
Alteryx
Alteryx

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

 

WilliamR_0-1577030282299.png

 

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

huynv96
9 - Comet

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
7 - Meteor

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 🙂

Labels