Google sheets input tool doubt

Kumarivaturi

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? 

gs1.png

gs2.png

DavidP

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.