Dynamic Input Read in Multiple Text Files at Once

[poles1c]

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

[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'.

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 · Accepted solution]

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