Issue with union in-db

[JYLim]

Hi community,

I am new to Alteryx and currently trying out the in-db functions in Alteryx. I am trying to data stream in to union with in-db tables but my union in-db icon is not giving any outputs. Is it possible that my data from connect in-db is all in string field and cannot union with the outputs from different fields from my stream in data?

I hope to get insights from the community regarding this matter.

 

[caltang]

Can we see your Union In-DB configuration pane? In addition, can you show us some data examples from the tools JUST BEFORE the Union In-DB tool? 

From your image and description, it's hard to pinpoint exactly the cause.

[JYLim]

Sorry for not being clear.

Before the in db tool, it is an auto field icon as below,

 

There are 69 field of data and some fields are shown below:

I am unable to share the data samples due to sensitive data issue but I can only provide explanation for this. The error pops up after is as below:

and the error pops up is as below

 

 

[JYLim]

I have tried to remove the auto field icon where all my data inputs are in string field, and the union in-db tool works. However, this is very inconvenient as everytime I tried to data stream in, I would need to change all the field of my data to string. I would like to know is this the only solution I can get to use union in-db?

[caltang · Accepted solution]

Hi @JYLim - no need to provide sensitive data, in this case. What you can do is to use the Multi-Field Formula tool before your Data stream in tool. Use the Multi-Field Formula tool, select ALL, and choose Dynamic also.

Then the expression, use:

ToString([_CurrentField_])

The config is something like this:

This ensures all data becomes V_WString or V_String or String as per your wishes, and it is dynamic. Then you should be able to use it in the DB Tool right? 

Try to use similar data types to SQL, then you'll have an easier time.

[JYLim]

Thank you very much for the suggestion