I have trouble with the aggregation of two excel files. These files have tons of columns and some of them don’t match up in terms of data format (string v. number). I know that I could use a number to string or string to number to make these merge.
However, this to me seems like a pain. Is there way to make this merge process default to one or the other without having to use a node?
Take a look at the
Table Manipulator node.
In the ‘Excel Reader’ node there is a tab called Transformation, where you can enforce the data type and column names.
Aiming to help with comparing the 2 tables, you can use ‘Extract Table Spec’ node.
With 4.4 this problem should be resolved.
Check this topic:
I’ve got a workflow that imports a CSV file and a Excel file to Join them.
Column 21 (and some more columns) occur to have only numbers in them, but not all the time.
When this happens the CSV reader and Excel Reader node get an error
ERROR CSV Reader 0:117:105 Execute failed: The column ‘Column21’ can’t be converted to the configured data type ‘String’. Change the target type or uncheck the enforce types option to map it to a compatible type.
The column type in Excel is set to St…
Any word on when 4.4 will be available?
I have read this summer, are you guys thinking more like August or sooner?
Server version 4.13 (together with Analytics Platform version 4.4) is scheduled for release at the end of this month (i.e. just over a week from now). However, this is a .0 release which is not recommended for production. We will release a production ready release a little later, you can follow this thread to get a notification on the release.
But think it’s still worth thinking about implementing
Table Validator (Reference) node as it covers much more than just column types differences…
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.