Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Google sheets input tool doubt

Kumarivaturi
5 - Atom

As can be seen in the first figure, the google sheets has loaded after running once. Now in the second figure, when I add data cleansing tool the fields don't get loaded like how it would have if it was 'excel input'. I should run the workflow again for the fields to appear in data cleansing tool.

What can be done to make it run like excel input? 

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @Kumarivaturi 

 

When connecting to an Excel file, Alteryx can identify the metadata (filed names, field types, etc.) before running the workflow and can therefore pre-configure the Data Cleanse tool. With the Google Sheets connector, however, since it's a remote connection and the metadata isn't available until the workflow is run, Alteryx can't pre-configure the Data Cleanse tool.

 

Depending on what type of cleansing you want to do, it may be possible to use something like the Multi-field formula, where you can use [_Currentfield_] and something like a Trim() function to remove whitespace.