ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

issue with pipe delimited CSV file on portal for data generation

book

Article ID: 227380

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I tried registering a pipe delimited CSV file on portal for data generation but instead of creating a table with columns as the per the delimited value, it created a table with only one column with all values.

There was no option to select the delimiter while registering the file.

Environment

Release : 4.9.1

Component : Web Portal - Generator

Resolution

   Engineering team confirmed that, we only support csv file in portal console. Other delimited files are considered as enhancement request. 

   As a workaround, convert the input file to csv (by replacing pile with comma) then register the file and then replace comma with pipe after re-generating the file