Fixed Decimal values on Dynamic header column

[Dhilip_Kumar]

Hi All,

My Headers are not constant and it given header came along with date. so i can i change those column into fixed decimal data type.
I have attached Actual input and expected output. Please help me on this.

[FinnCharlton]

Hi @Dhilip_Kumar , if I've understood correctly, you want to change your data type to Fixed Decimal, but can't do it dynamically as the field names change? If so, I recommend using the Multi-Field Formula tool. You can choose to change all Dynamic and Unknown Numeric (or text, if they come through as strings) fields into Fixed Decimal type. This will pick up new field names, like ones with new dates, and change their data types:

[Peachyco]

< EDIT: Oops! This advice is exactly the same as Finn's above. Just a timing issue, my browser hadn't loaded his earlier response by the time I posted this. ^_^ >

I think the Multi-Field Formula tool can work here:

• Select "Numeric" fields, and make sure to tick the box for "Dynamic or Unknown Fields". This will catch your numeric fields, regardless of their column name.
• Untick the box for "Copy Output Fields and Add". We are changing an existing column, not adding new ones.
• Tick the box for "Change Output Type to", and select "FixedDecimal" there.
• In the Expression box, just put "[_CurrentField_]". This just puts the same value there, but now we're switching the type to FixedDecimal.

 

[Dhilip_Kumar]

Thank you so much Peachyco and FinnCharlton.