How to make Dynamic Input to read data as V_String always

Hi all,

I have excel file with 11 sheets and the number of sheets will grow. All sheets have the same number of columns and naming convention. I'm reading data from all sheets using Dynamic Input, but the problem occurs when Alteryx recognizes one column from one sheet as Double and same column it recognizes as V_String when it reads from different sheets. In excel file, all columns are type text.

Is there any idea how to bypass this problem? I want Alteryx to read this column always as V_String, not sometimes Doble, and sometimes V_String.

Example of data in attachment (example1,example2). In sheet image is the example of real scenario.

Thank you for your time.

example_file.xlsx

Workflow

Tips and Tricks

Preparation

Accepted answers

AngelosPachis

Hi @tanja90 ,

Unfortunately I wasn't able to recreate the error you are getting with the provided dataset. I used a dynamic input to load in the different sheets and Alteryx read all columns as V_String.

A way I would suggest however to tackle this issue is using a batch macro.

In this batch macro, I am feeding in the different sheet names in my control parameter (so every time the batch macro runs the sheet name will change and a different sheet will be read). And then I have included a select tool to force the data type to be V_String for all columns.

Now even if Alteryx reads a column as a double, that select tool will convert it into a V_String, and output the data in the correct format.

Give this a try and let me know if it worked for you.

Cheers,

Angelos

example_workflow.yxzp

All comments

Qiu

@tanja90
Alteryx is not allowing the mixed data type.

Maybe we can do something like this.

AngelosPachis

Hi @tanja90 ,

Unfortunately I wasn't able to recreate the error you are getting with the provided dataset. I used a dynamic input to load in the different sheets and Alteryx read all columns as V_String.