top of page

About Data Table

Jul 9, 2024
2 min read

Last time I created an output file using a data table.

An issue occurred where all output results were in string format.

To avoid this, we used a double loop when writing the output file instead of using the "Write from Data Table" action.

However, this method is fine if you only need a small amount of data.

This is fatal when the amount of data is large.


Is it possible to get the data into a data table in the correct format when retrieving it?

I tried it. There is something called "Change column type".



In this input file, column B contains numbers and column E contains numbers (dates).

Column E of the input file is originally in YYYY/MM/DD format, but even if I set the "Change column type" action on line 5 above, an error would just occur. Therefore, I have deliberately left it in the screenshot state.


I also tried using the official date and time format below, but it didn't work at all.


I also tried the official date and time format below, but it didn't work at all.


I'll show you the results of actually running it.



The actual processing result is as follows:

Even though column B was converted to a number, it was recognized as a string and contained a decimal point.

It also specifies the time zone and location (city), which is far from the format I chose for column E.

So I edited it into a video.

I don't know if I'm doing it wrong, but isn't this a terrible tool?

This is the first product that can output in a format other than the specified format.

*By the way, I selected the date format in the first image above. I selected BASIC_ISO_DATE('20111203")


Format conversion is a common process, and I sometimes sort by date, so the current way of doing it is difficult. If anyone knows the correct way to do it, please let me know.


By the way, I asked Microsoft Copilot and they said this is a bug or a feature.





Comments


bottom of page