Datatype mismatch in Javelin table export
search cancel

Datatype mismatch in Javelin table export

book

Article ID: 377926

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Working with Javelin flows and Export Data Table activity in excel files. The columns that contains numbers (for example when data table type is “Decimal”) are exported in text format, and workarounds are needed to convert directly into excel file.

Is there a solution/suggestion for that?

Environment

Javelin 4.11.0.X

Cause

By default, existing Export to DataTable activity does set all Excel cells as Strings when exporting.

Resolution

Attached is an example flow with a few steps added to fix all numbers to be handled as numbers and not strings anymore.

Attachments

ExportDataTableandFixNumbersExcel.vwf get_app