String instead of Int64

[czello]

I'm working on Weekly Challenge #49 and am confused why I get an error when the Value is set to a type of Int64, due to decimals being dropped.  The error is "lost information in translation". 

I'm doing a Join in the next to last step, and see that when I change the type to String, there is no error.  I'm working with a column that has numbers in it, with decimals and don't want to lose that.

Thanks.

[Yoshiro_Fujimori]

@czello ,

It would be better to ask this question in the Challenge #49 thread.

That said, it seems the challenge does not ask you to convert the original string to number type.

[czello · Accepted solution]

I think I figured it out, as using a Float type works best of all.