How to attend this alert?
Reading the help, I can't figure out what to do!
Is it possible that you have inconsistent results for it?
In melt.data.table(dtODU[, .SD, .SDcols = is.numeric], id.vars = c(1)) :
'measure.vars' [TargetFreq, ActualFreq, OAT, HST, ...] are not all of the same type. By order of hierarchy, the molten data value column will be of type 'double'. All measure variables not of type 'double' will be coerced too. Check DETAILS in ?melt.data.table for more on coercion.
Below are examples of data tables that do and do not raise the warning you see. In the first case, column B contains double values and column C contains integers. This raises the warning about values of different types. In the second case, columns B and C are both doubles and there is no warning. What types of data do your columns have? Is conversion to double a problem for you?
Can you post a bit of data from the data table that you are trying to melt and also the actual melt command you are using? You can use the dput function to make a cut-and-paste friendly output. Please post the out put of something like:
as @FJCC asked, is converting to double a problem? This warning will come up because some of your numeric columns are integers and some are double. It's just letting you know that the value column in the resultant melted data.table will be a double. It needs to choose one type since the column will be a vector and double is the most obvious choice in these situations.
You can always suppress warnings if you want. Or you can just convert all your integer columns to doubles or numerics