Date Field converts to V_WString in Alteryx

Hello All,

I have a macro that reads data from SQL server and then I use the data from this macro in another workflow. After certain data manipulations, I publish it to Tableau Server.

The issue I am getting is that there is a 'date' field in one of the sql tables that is a part of Macro Output. When the other workflow reads the data from Macro Output, it assigns 'V_WString' type to this field and therefore, the tableau dashboards throw error. It used to work fine on my team member's machine strangely.

Any advise on how this can be resolved? I tried using 'DateTime' function but when I use it, this function does not recognize the field as string type so does not appear and hence, I cannot convert it to 'Date' type in the workflow.

Thanks,

Suruchi

Date Time

Accepted answers

JoshuaGostick

Right, I see.

What about using a Multi-Field Formula tool after the Macro Output?

Try configuring the tool like the screenshot below. Select the specific date field. Deselect Copy Output Fields Add. Then, select Change Output Type to and change the type to a Date. This will ensure that the field is Date type regardless of whether it comes through as a date or a string.

Finally, under Expression, have [_CurrentField_].

Let me know if this works!

All comments

JoshuaGostick

Hi @Suruchi23 ,

Do you have access to edit the macro? If so, you can maybe try adding a Select tool just before the Macro Output tool to force the field to be a date field.

Josh

Suruchi23

Hi JoshuaGostick,

Thanks for your quick reply!

The macro uses 'In-database' tools and the select tool in there does not give me any option to change the data type.

Regards,

Suruchi

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703