Check file format

[dkma]

How to find the file format of a file given in input tool. 

If the file format is excel (xls*)- then perform a separate operation

if the file format is CSV - then perform another opertaion. 

But the data in both files are almost same

[drew9]

Hi @dkma ,

What is your use case? Off the top of my head, you can output the full path of the file and then search for a string (.csv, .xlsx, etc.) within the filename in your formula or filter tool.

[Garabujo7]

Hello @dkma , you may try this:

And then select the extension you'd like to use:

You may filter .xlsx or csv and use it accordingly.

Gabriel

[SubratDas5]

You can use the directory tool to read all files in the directory irrespective of the file type , then use the dynamic input tool(s) to read the data from .csv separately and the .xls* separately and act further.