In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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
19 - Altair
19 - Altair

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