Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

get the 4th row of each file

PassION_es
10 - Fireball

Hello,

 

Requesting your assistance of the batch macro to use by reflecting in the output the 4th row of each file with their filename:

 

Assuming I have hundreds of files other than the dummy input files I have attached.

 

Thank you.

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

Can you read in all data, use a Record ID tool, then a Filter tool to take whenever the remainder of the recordID divided by 4 equals 0?

 

MOD([RecordID],4) = 0

FrederikE
13 - Pulsar

Hey @PassION_es,

 

You can set the import line in the input tool on "3" (the header) and use a wildcard input.

 

Unbenannt.png

binuacs
21 - Polaris

@PassION_es one way of doing this with the batch macro

Screenshot 2023-07-16 174940.png

PassION_es
10 - Fireball

hi @alexnajm @FrederikE @binuacs .  Thank you all. Your solutions helped to modify my workflows and arrive at the right solution.

Labels
Top Solution Authors