Generate Data Table - Specify Data Types

Help
1

I’m using Generate Data Table to parse a ~ delimited file into a data table.
AutoDetectTypes converts some values to the wrong types - losing leading zeros.

Is there any way to specify the types manually when using Generate Data Table?

Thanks

1 Like
2

Hi @andrewjames

I don’t think it is currently possible to do. I suppose the only workaround for this particular activity is to not use the AutoDetectTypes option and handle the conversion afterwards.

I’ll record this bit of feedback though for our team’s future reference. Thanks for reporting it!

1 Like
3

Thanks @loginerror

This is essentially what I ended up doing, but it became a problem when I tried to filter the datatable, however I worked around this by doing some manual filtering in a For Each Row loop.

1 Like
4

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