Dynamic input tool generates only Null values

Question

Hi all,

perhaps it is because I have not been able to work on my Alteryx flows for several months and so I am a litte rusty but I have been trying to resolve this but cannot find the reason why the Dynamic Input generates all Null values.

The File path is recognized from the FullPath Field. The number of Records is correct when looking at the input file, yet the data is not recognized.

Any ideas would be much appreciated, thanks.

Roger

Alt 3.jpg

Alt 1.jpg

Alt 2.jpg

OTrieger · Answer

Potentially yes, if you only need to populate cell A1 with specific data then yes.

You can use Blob tool to import the whole file as a template therefore the data will not be impacted, and then write to cell A1 the needed label.

Greenlama254 · Answer

I just discovered what the problem is.

Our company security requires us to select a sensitivity label on all/most reports.

This however requires a manual action before running this tool, otherwise the data is not imported (correctly)

Is there a way around this?

Alt 6.jpg

Greenlama254 · Answer

Yes it is reading in the correct sheet.

Basically it has to import the latest of a daily report which is selected by sorting on date.

I can see in the filter tool that the right report is filtered and the correct full path name is shown. Also, the bottom summary tool is counting the Record number of the imported file and that is correct as well. It's just that all the data is showing Null values instead of the original values.

Not sure what you mean by "Where does the data import start" ..?

Thanks

Roger

Alt 4.jpg

Alt 5.jpg