Dynamic input tool generates only Null values

[Greenlama254]

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

[alexnajm]

Is it reading in the correct sheet in the file? Where does the data import start in your dynamic input?

[Raj]

@Greenlama254 will you be able to add the sample data 
will be in better position to help.

[Greenlama254]

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

[Greenlama254]

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?

[OTrieger]

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.