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. NameTypeSizeScaleRight_NameRight_TypeRight_SizeRight_ScaleACCUM_DIVD_AMTFixedDecimal194ACCUM_DIVD_AMTFixedDecimal192ADMN_SYS_CDEV_WString50 ADMN_SYS_CDEString8 ADV_PREM_REFUND_AMTFixedDecimal194ADV_PREM_REFUND_AMTFixedDecimal192ADV_PREM_REFUND_QLTY_CDV_WString50 ADV_PREM_REFUND_QLTY_CDString10 AGMT_HIST_FR_DTDate10 AGMT_HIST_FR_DTDateTime19 AGMT_TOT_ANNUAL_PREM_AMTFixedDecimal194AGMT_TOT_ANNUAL_PREM_AMTFixedDecimal192AGREEMENT_PAYMENT_TIME_PERIODV_WString50 AGREEMENT_PAYMENT_TIME_PERIODString4 AGREEMENT_SOURCE_CDV_WString50 AGREEMENT_SOURCE_CDV_String20

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

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

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

Datasets

Accepted answers

All comments

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/td-p/672616

Pravallika20

Hi @swhitmeyer

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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703