Write CSV data missing error

Help Studio
, ,
1

Hi EveryOne,
Can any please help me out with write CSV activity. I have a collated data table of more than 5 excel file with around 10215 rows. I’m using to write same data table in .csv file, but in .csv file I’m getting 203 rows only. Is this expected?

Thanks
`

2

@Codeverse,

What activities you are using and is the delimiters specified? Share more details.

3

@Codeverse

  1. First confirm the row count before running the csv write activity using dt.rowcount inlog message
  2. If rowcount is proper then can you tel what deimittr is used

Cheers

4

I’m using Write CSV activity with comma as delimiter.

Thanks

5

Hi @Anil_G,

I tried same, However I’m getting exact count of data row before and after writing but I’m only able to see 203 rows in CSV is this expected.

  1. Before writing I have collated data table in data row is 14805, After writing in CSV, I’m reading it and getting same number of data row.
    image
    image

  2. But In CSV file I’m able to see only 203 rows.
    image

6

@Codeverse

Can you please open the csv file using and notepad and check

Ideally that wont be the case…so please verify in notepad if data is missing…what I assume is there is some character in the data that is spoiling the format to xisplay in excel

Cheers

7

@Anil_G You guess it right, it seems some character messing it up the data in CSV. Thanks for your help I’m looking into it.

image

1 Like
8

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