Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

How to read and write files using Alteryx Designer Cloud

javier_rios
Alteryx
Alteryx

Pre work:

Data set from Kaggle to solve the Weekly Challenge #358

Data Source: www.kaggle.com/datasets/nasirkhalid24/the-office-us-complete-dialoguetranscript

Save the data into your local computer. I saved it Desktop (Mac user)

File Name: The-Office-Lines-V4.csv

 

How to read and write a CSV file

 

  1. Open Designer Experience – double click on the icon

 

javier_rios_0-1676495672759.png

 

  1. Click on Create New Workflow. The canvas will be ready, and you can start building your workflow

javier_rios_1-1676495672782.png

 

 

 

 

javier_rios_2-1676495672785.png

 

(Tip: you can drag and drop the Input Data tool from the tool window to the canvas)

 

  1. Once the Input data tool is in the canvas, click on it and the configuration window will appear to the right. Click on the Upload File button and search for your file

 

 

javier_rios_3-1676495672801.png

 

 

  1. Once you find your file, select it and click on Open

javier_rios_4-1676495672876.png

 

 

  1. Once the data is loaded, you will see the file, edit the options as necessary and then click on Create Dataset (Hint: you can click on Preview to make sure your selections in the OPTIOS field are the correct ones)

 

javier_rios_5-1676495672911.png

 

 

 

  1. You can click on the output anchor of the Input Tool to see the data in the result window located at the bottom of your screen.

 

javier_rios_6-1676495673035.png

 

 

  1. To write a file in your computer drag and drop the output tool from the Tool window. Connect the input with the output as shown

(Tip: Double click on any icon located in the canvas to add an annotation or right click on it and select the option Add Annotation, this will be very useful to keep your workflow tidy and readable)

 

javier_rios_7-1676495673058.png

 

 

 

  1. Click on the Output tool, the configuration window will show at the right of the screen. On that window, click on the Download File button

 

javier_rios_8-1676495673068.png

 

 

  1. A new menu would appear, name the output file. In the example I name it: output_csv_example. Make sure the selections are the correct ones on the OUTPUT OPTIONS section and then click on SAVE

 

javier_rios_9-1676495673098.png

 

 

VERY IMPORTANT – you will need to Run the Workflow to generate the output

 

javier_rios_10-1676495673123.png

 

 

  1. Proceed to save your workflow. Click on File at the top menu, then click on Save As…

In the example we name it: read_write_workflow. Finally click on Save

 

javier_rios_11-1676495673137.png

 

 

  1. The Run Jon button at the top right corner won’t be grayed out. Click on Run Job. This will create a job and a job ID. Once the job is done a message will pop up

 

javier_rios_12-1676495673140.png

 

 

 

  1. Once the job is finish running, click on the output tool, click on the Job number created

 

 

 

 

javier_rios_13-1676495673168.png

 

 

  1. A new window will appear. Click on the Download Output File button. (Tip: you will find details about the job you just run, like status, start and finish time)

 

 

javier_rios_14-1676495673190.png

 

 

  1. The file is created using Designer Cloud

 

javier_rios_15-1676495673206.png

 

 

Congratulations – you now know how to read and write CSV files 💥 :dbfileinput: :dbfileoutput: 😍

 

 

 

 

 

 

2 REPLIES 2
javier_rios
Alteryx
Alteryx

Hi James - 

 

Thanks for your response.

Could you please share a screen shot of the window you select the different input/output formats please?

 

Thanks a lot

josemendonca
7 - Meteor

Hi! Thanks for the guide. I have a question, could you import multiple csv files with the same column structure using a wildcard like in the designer?