Input file either csv or xlsx

[Dhilip_Kumar]

Hi All,

We received input file either csv or xlsx file format so we have to process out workflow on both types. Headers also not given on both type input files so we need to extract entire data and adding header manually for both csv and xlsx format. I have attached my workflow and input and expected result. please do the needful.

[Prometheus]

@Dhilip_Kumar Can you please export your workflow? I downloaded your workflow and opened it, but there's a tool in it that doesn't show up. If you export it, all your data sources and macros will be contained in the workflow when I open it. Thanks.

[Dhilip_Kumar]

Hi @Prometheus, I have export my workflow as well as screenshot of tools which i used in workflow. Please do the needful. If this will not work please suggest some example workflow to execute my inputs.

[Prometheus]

@Dhilip_Kumar By export, I mean to go to Options, then click on Export Workflow. It'll take your data sources and macros and put them into an Alteryx zip file that can then be downloaded and users won't get that black box with a question mark in it, but they will get the macro you're actually using in your workflow. Thanks.

 

 

 

 

[Dhilip_Kumar]

@Prometheus I used this workflow as an example and tried my workflow. now I am also getting same error like you. Could you please give me any sample workflow to me to create workflow for me. if you could, that would be very helpful to me.

[Prometheus]

@Dhilip_Kumar If all you're trying to do is open up CSV and/or XLSX files, you can bring them all in with a Directory tool, then open each up with a Dynamic Input tool. Since you don't have any column headers, just make sure your Dynamic Input tools are configured where the First Row Contains Field Names check box is unchecked.

 

[Dhilip_Kumar]

@Prometheus You are the best!!!! Its works for me. Thanks a lot

[Dhilip_Kumar]

@Prometheus I got error on above workflow if input file given as csv format alone. Actually, My condition would be we received input file either csv or xlsx we need to run it without any error. If i ran with csv file i got error "can't find the file:". Please help me.

[Prometheus]

@Dhilip_Kumar Can you post a screenshot of the tool with the error?

[Dhilip_Kumar]

@Prometheus Here is the error message on dynamic input.