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

binu_acs
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 @binu_acs .  Thank you all. Your solutions helped to modify my workflows and arrive at the right solution.

Labels
Top Solution Authors