Multiple Input file format

[vijaylnyadav]

Hi,

Please help me and a little bit urgent.

I want a workflow in which we require to design an interface.

It should ask for 15 input file(e.g xls, xlsx, csv, txt, dat) with a selection of sheet names (as user have different sheet names) and also the delimiters for txt, dat, csv files.

The user have a multiple files with different file formats in mix.

one input file can accept any type of file format and should ask for sheet names.

If user inputs 4 files then all the other input files which are left blank shouldn't throw an error.

Please suggest some solution or workflow for this.

Thanks, it will be great help because i am in urgent

[Ladarthure]

Hi @vijaylnyadav ,

one solution would be to use an analytic application and include radio buttons allowing you to select either one type of file. You can also use the interface tool file browse which allows some customisation!

[vijaylnyadav]

@Ladarthure  can you please share some workflow for this so that I understand what you are exactly explaining

[Ladarthure]

Find attached an example, not very ellaborate but it works!

[vijaylnyadav]

Hi @Ladarthure thankyou for your effort.

Can you please build a similar workflow where we are asking from user about 10 input file format and it should ask as a choice from the user as below:

1. Excel(.xlsx) with sheet name

2. Excel(.xls) with sheet name

3. CSV File (.csv) with sheet name and delimiters

4. text files (.txt) with sheet name and delimiters

5. Dat files (.dat) with sheet name and delimiters

Please share the workflow so that i can implement and mark this as a solution

Thanks Once again for your help

[Ladarthure]

@vijaylnyadav,

I will let you do it by yourself, I gave you an idea about what to do. For the next steps, it is up to you.

The community will be pleased to assist you, help you understand about how you can do it, but won't do it for you directly.

[vijaylnyadav]

ok  then please help on what template to give in input file so that I can edit the delimiter and sheet names.

[vijaylnyadav]

Hi @Ladarthure Please find the below workflow i have edited.

But I am not getting the solution. Can you please refer and tell me what I am doing wrong.

If i am using CSV as a template then I am able to perform an action tool on delimiter but unable to perform on sheet action tool.

If i am using XLS as a template then i am able to perform an action tool on sheet but unable to perform on delimiter action tool.

[Ladarthure]

I updated your applciation and modified directly the xml of the tool to replace the delimiter if there is one, if not it should not change the data itself. It might need a bit of tuning, in the case of an exccel file, you would not need to select the sheet since the file browse interface tool does it by itself.

formula below for the xml : replace([Destination], "<Delimeter>,</Delimeter>",
"<Delimeter>"+[#1]+"</Delimeter>")

[vijaylnyadav]

Hi @Ladarthure  i am getting the following errors.

The Action Tool #5 has an error: The file ********.txt is not a known format.

This error comes for text file

No table chosen; Please select a Table from data source. (for xls file)

The Action Tool #5 has an error: The file ********.txt is not a known format.

This site comes for dat file

for xlsx file it is working fine

for csv file it is working fine

Please help me on this