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
