Dynamic Sample Tool

gmerce

Hi,

I have a directory whith hundreds of Excel files. I wanted to use the dyncamic input tool to import my data in Alteryx.

Unfortunately my table headers are on the row #15 so I wanted to use a Sample Tool (with the Skip 1st N records option).

I can't do the Dynamic Input Tool and the Sample Tool at the same time... I'm stuck on this problem and I don't identify any solution to do this properly.

Does anyone has encoutered the same problem ?

Thanks a lot.

Gilles

scottj

I would suggest using a Batch macro to read and merge each file.  Set up a Text input with a sample of the location of the file (from the directory tool).  Then use the Dynamic input to read in the file followed by a sample tool to remove the first N rows, and finally a Dynamic Rename to take the field name from the first row of data.  That stream goes into a Macro output.

Now us a Control parameter and attach to the Text input.  Use the default action to update the file name.

I have attached an example of what I mean.  It looks to my directory, so it needs editing, but you should get the idea.  Run the directory tool into this macro and all files are merged to work with in Alteryx.

BatchLoadCommunity.yxmc