Input file either csv or xlsx

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.

Test 1.csv.csv

Expected Result.xlsx

Test 1.xlsx.xlsx

Test Workflow 1.yxmd

Developer

Input

Tips and Tricks

Macros

Interface Tools

Accepted answers

All comments

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.

Test Workflow 1.yxmd

Workflow tools.docx

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.

Export Settings.PNG

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.

challenge_180_Joe_Serpis.yxzp

11.xlsx

FileImport_Macro.yxmc

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.

No Headers.PNG

Open CSV and XLSX.yxzp

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.

Error Image.docx

Prometheus

@Dhilip_Kumar Is the error calling out the file that the Dynamic Input is mapped to? Are the Dynamic Input tools mapped to existing files? The file that you map the Dynamic Input tool is not the file you're trying to open. It's just a placeholder that will be replaced by the incoming FullPath from the Directory tool.

DI Config XLSX.PNG

DI Config CSV.PNG

This is what happens when I run the workflow and nothing is in the folder that the Directory tool is mapped to.

No Files to Input.PNG

Dhilip_Kumar

@Prometheus I had only csv file as input file for this workflow that is why we got error on xlsx part i believe. If we put some dummy xlsx file in the folder then we do not get any error but if we put any dummy data headers are update twice since we use join tool to connect xlsx and csv. Please advise me.

Prometheus

@Dhilip_Kumar By input, do you mean that you have only a CSV in the folder that the Directory tool is pulling in from? I was asking if your Dynamic Input tools are mapped to existing CSV and XLSX. One needs to be mapped to an existing CSV and the other needs to be mapped to an existing XLSX. Then if there's no CSV or there's no XLSX, there's also no error.

This is what it looks like when I have no CSV in the input folder:

No CSV.PNG

This is what it looks like when I have no XLSX in the input folder:

No XLSX.PNG

No errors.

Dhilip_Kumar

@Prometheus let me answer your question first,
By input, do you mean that you have only a CSV in the folder that the Directory tool is pulling in from? - Yes
I was asking if your Dynamic Input tools are mapped to existing CSV and XLSX. - Yes

So you said, if we mapped to existing CSV and XLSX it means we need to keep one CSV and XLSX file particular folder always?

Dhilip_Kumar

@Prometheus I can see your above workflow but i got error while merging those two output into one result. So could you please advise how could get the result on your workflow. I need only one sheet as output either the input format is CSV or XLSX.

Prometheus

@Dhilip_Kumar I'll answer your question first. "So you said, if we mapped to existing CSV and XLSX it means we need to keep one CSV and XLSX file particular folder always?" No. The folder that the Directory tool is mapped to can be empty, like this:

No Files to Input.PNG

The Dynamic Input tools have to be mapped to something that exists, like this:

CSV mapping.PNG

XLSX mapping.PNG

I'm not actually pulling in data from either of these files. They're just serving as placeholders. The path to open them will be replaced by the FullPath from the incoming Directory tool.

Dhilip_Kumar

@Prometheus Could you please advise how to get output as single sheet for both xlsx and csv. That would be helpful to me.

Prometheus

@Dhilip_Kumar Try this.

Open CSV and XLSX.yxzp

Dhilip_Kumar

@Prometheus I apologies for continuous questions. I tried this workflow got same error. I have attached my workflow and error message with configuration settings of input.

Please edit that workflow and help me.

Error Image.docx

New Workflow6.yxmd

Prometheus

@Dhilip_Kumar From what I can see in your workflow, you haven't mapped the Dynamic Input tools to existing files.

Go to the Dynamic Input tool and click on "Edit."

DI Config XLSX.PNG

Then click on "Set up a connection"

XLSX mapping.PNG

Then select an XLSX file to connect to. You'll know you have a good connection when you see data in the bottom part of the above screenshot -- Preview (first 100 records). Make sure your Dynamic Input tool is going to read in the FullPath from the Directory tool by clicking on the radio button next to "Read a List of Data Sources." Select "FullPath" from the "Field:" dropdown menu, then select "Change Entire File Path" from the "Action:" dropdown menu.

Read List of Data Sources.PNG

When you run your workflow, the FullPath from the Directory tool will replace the path to the file you selected. You should not have errors.

Dhilip_Kumar

@Prometheus Thank you so much. Now it is working perfectly to me after changing the configuration as same as above.

Thanks you so much for your timely help!!!! Much appreciated!!!!

Regards

Dileep

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703