Forum Discussion
Solved
formatting
Hello, i'm appending two tables with two columns: One is projects and the other is actuals.. The issus is that actual come in idfferent formats. In table one is regularnumber let's say: 100.000 € th...
Hi i4696,
The best way is to do it in the query editor, maknig the formatting change creating a new column and then deleting the previous one. The query editor is like a macro and every single time you update your data the steps are run and your information is prepared as your need, and you don't need to make the changes on the original data.
Regards,
MFelix
MFelix
Super User
Super UserHi i4696,
The best way is to do it in the query editor, maknig the formatting change creating a new column and then deleting the previous one. The query editor is like a macro and every single time you update your data the steps are run and your information is prepared as your need, and you don't need to make the changes on the original data.
Regards,
MFelix