Floating Decimal

kim_barragan0126

I am trying to connect to data sets together, but I continue to get the message of remove 1 column, Budget DH TTH: Floating Decimal, after run the preview, but in my preview, I see there is a floating decimal. I also try to add it in the alter columns, but it still doesn't fix it. Any ideas?

marcel_luthi

That is expected, when you Append 2 files, at the end you need a consolidated set of columns that will remain in the appended version, this means if they do not have the same columns, like in your case, that one of the following will happen to 1 or more of the original sources being appended:

• Columns will be deleted usually when the Columns to include in the Append is set to one of the sources, this is the original scenario you showed.
• Columns will be added usually when the Columns to include is set to Include all columns which is what you're seeing in the second attempt.

If neither of these is what you're looking for, you'll need an Alter Columns to rename them in a consistent way across the ones being appended, or perhaps you're not looking to append (which is adding the rows from multiple datasets together in a single list) but to join (which is adding columns from multiple datasets together into "merged" rows).