Dynamic Input Read in Multiple Text Files at Once

Hi,

I am trying to read in multiple text files at once using the directory and dynamic input tools.

My Input Data Source Template field is:

\\ecc9000106\qlik_prod8422\Analytics\Log\QlikView_Legacy\Pilot\QDS_Task_Logs\20170529\030300 - FBR_DEV_qvd_BOMWERSCompare\TaskLog.txt

And I am passing the full paths of the files I want read to the Read List of Data Sources Field.

I am getting the below error:

Error: Dynamic Input (42): File not found "\\ecc9000106\qlik_prod8422\Analytics\Log\QlikView_Legacy\Pilot\QDS_Task_Logs\20170529\030300 - FBR_DEV_qvd_BOMWERSCompare\__ecc9000106_qlik_prod8422_Analytics_Log_QlikView_Legacy_Pilot_QDS_Task_Logs_20170529_030300 - FBR_DEV_qvd_BOMWERSCompare_TaskLog.txt.txt"

Will someone help me understand what I am doing wrong?

Thanks!

Courtney

Preparation

Accepted answers

vishwa_0308

As you reading multiples files through Directory then you should read the file from "FullPath" field and action will be " Change Entire Full Path". Please refer as settings below:

All comments

MSalvage

@poles1c,

Not 100% on this, but judging by the error message you are inserting an entire file path into the file name. Make sure in the dynamic input you have selected 'Change Entire File Path'.

dyn input.PNG

Hope this helps,

Michael

jrgo

@poles1c

The suggestion from @MSalvage should help, however, you may need to evaluate how your replacement file path is being constructed. It looks like all you backslashes “\” are being replaced by underscores “_” somewhere in your process.

vishwa_0308

As you reading multiples files through Directory then you should read the file from "FullPath" field and action will be " Change Entire Full Path". Please refer as settings below:

poles1c

Doh! Of course lol...thanks!

MSalvage

@jrgo,

Interestingly enough I think Alteryx is changing the "\" to "_" because you cannot have "\" in a file name.

-MSalvage

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703