Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Read Multiple CSV files using Dynamic Input

JenzEkan
8 - Asteroid

Hey Guys,

 

I have a requirement in which I need to read multiple csv files. i am using a macro for this but is there a way to use a single tool to perform this. i tried using Dynamic Input tool but its giving me an error because my data contains few records in the start that need to be skipped.

3 REPLIES 3
ShankerV
17 - Castor

Hi @JenzEkan 

 

Here is one way to read multiple .csv files without macro and dynamic input.

Check whether it works out for you.

 

ShankerV_0-1673855171379.png

 

Input was:

ShankerV_0-1673855299718.png

 

To skip data/records, modify the Value 1 to the respective number from where the read data needs to be read.

 

ShankerV_0-1673855600542.png

 

 

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

 

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @JenzEkan 

 

++ Change in setting

 

By changing the below setting, will help to understand which data has been read from which file.

 

ShankerV_0-1673855407960.png

 

Many thanks

Shanker V

grazitti_sapna
17 - Castor

Hey, You need to use the below configuration as per your requirement.

grazitti_sapna_0-1673856204755.png

 

Sapna Gupta
Labels