Warning Message Extract and use as an input

[SaadNaser]

Hello Community 

i am using the *.xlsx in the path of the input data tool to import all the excel file at once. yet some of the file has different structure and as a result a got a warning message by those file full paths.

i need to import those files with a warning in a in a different input to be processed in a different stream.

what i have done is the following:

1- i have copied the warning massege and past them in a text input> Cleansed them to keep the full path only> Output tool to show only the paths.

2- Input tool for the new excel sheet that contained a the file paths with the warning. and then i have used a dynamic input to use the paths existed in the excel sheet as an input. yet it does not seems to be a solution.

any one have a solution for that issue would appreciate that 

[Qiu]

@SaadNaser 
How about enabling the logging by specifying a output folder?

[SaadNaser]

i have changed the setting based on the screenshot that you have send and then i can see that there is an output generated same as the notepad.however it contain the path. actually i need to use these paths as an input. like to use the first path in the generated file and to be used by the input tool to get the data from that path.