Data type

[swhitmeyer]

Hi - I am trying to change the data Type, Size and Scale of one data source (right side) to another data source (left side), see sample data below.

Name	Type	Size	Scale	Right_Name	Right_Type	Right_Size	Right_Scale
ACCUM_DIVD_AMT	FixedDecimal	19	4	ACCUM_DIVD_AMT	FixedDecimal	19	2
ADMN_SYS_CDE	V_WString	50		ADMN_SYS_CDE	String	8
ADV_PREM_REFUND_AMT	FixedDecimal	19	4	ADV_PREM_REFUND_AMT	FixedDecimal	19	2
ADV_PREM_REFUND_QLTY_CD	V_WString	50		ADV_PREM_REFUND_QLTY_CD	String	10
AGMT_HIST_FR_DT	Date	10		AGMT_HIST_FR_DT	DateTime	19
AGMT_TOT_ANNUAL_PREM_AMT	FixedDecimal	19	4	AGMT_TOT_ANNUAL_PREM_AMT	FixedDecimal	19	2
AGREEMENT_PAYMENT_TIME_PERIOD	V_WString	50		AGREEMENT_PAYMENT_TIME_PERIOD	String	4
AGREEMENT_SOURCE_CD	V_WString	50		AGREEMENT_SOURCE_CD	V_String	20

[RolandSchubert]

Hi @swhitmeyer ,

if you want to do this within a workflow, all changes should be possible using a Select tool, just select the data type and size. There is no specific conversion needed.

Best,

Roland

[swhitmeyer]

Thanks, I need to change over 300 fields for multiple tables so I was hoping there was some dynamic lookup way to do this. It would take too long to go through each field within the select tool. 

[Christina_H]

This discussion might be helpful:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-change-data-type-of-fields...

[dYoast]

Where is your data coming from?  Is it possible to change the types at the source?

I know this could be done in SQL Server using views and CAST AS datatype.

[Pravallika20]

Hi @swhitmeyer 

Did you try using Multi Field formula tool? You can change columns with the similar datatype at once

[swhitmeyer]

Unfortunately the data source changes so I want to convert the input data to look like it has in the past so it flows through all my workflows

[Pravallika20]

Hi @swhitmeyer ,

Can you please provide the sample input , output files and elaborate your problem statement 

[swhitmeyer]

@Pravallika20 Same data is provided in original post. I am trying to change the data Type, Size and Scale of one data source (see the first 4 fields of sample data) using the data Type, Size and Scale of the last 4 fields. For example for AGMT_HIST_FR_DT, I need to change from DateTime 19 to Date 10. Hopefully that makes sense.