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
9 - Comet

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
16 - Nebula
16 - Nebula

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
20 - Arcturus

@PassION_es one way of doing this with the batch macro

Screenshot 2023-07-16 174940.png

PassION_es
9 - Comet

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

Labels