Unsupported Column Type - String V. Data

rparr009 · June 22, 2021, 3:20pm

Hi,

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?

HansS · June 22, 2021, 3:30pm

Hi @rparr009

Take a look at the Table Manipulator node.
gr. Hans

gonhaddock · June 22, 2021, 7:17pm

Hello @rparr009
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.

Regards

ipazin · June 23, 2021, 10:45am

Hello @rparr009,

With 4.4 this problem should be resolved.
Check this topic:

Br,
Ivan

rparr009 · June 23, 2021, 1:27pm

Any word on when 4.4 will be available?

I have read this summer, are you guys thinking more like August or sooner?

ipazin · June 23, 2021, 1:36pm

Hello @rparr009,

sooner

But think it’s still worth thinking about implementing Table Validator (Reference) node as it covers much more than just column types differences…

Br,
Ivan

system · December 23, 2021, 1:37am

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.