Input file either csv or xlsx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
 
 
 
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Prometheus You are the best!!!! Its works for me. Thanks a lot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dhilip_Kumar Can you post a screenshot of the tool with the error?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Prometheus Here is the error message on dynamic input.
