Handle first line in output

Help Activities
1

Hi can anyone help in fixing the first line issue

Everytime I try to get the output in CSV I am getting the first row after header as
,

17096142280262675107766402803090
170961422802626751077664028030901920Ă—1440 293 KB

Cn anyone help

2

Hi @dipon1112000
check this link

hope this might help

3

Thank you but the first line is getting generated in the output file as I am using add data row so if this can be mitigated while generating then it will not show up in input

4

Hi @dipon1112000 again.

For your process, since it’s unstructured data, I believe you have separated few parts.
For the header / generate the data schema, you may follow below 2 steps. Then you could add data row to data table.

  1. Assign
    csvLines = File.ReadAllLines(“testExample.csv”).ToList()
    Variable type of csvLines is System.Collections.Generic.List<System.String>.
  2. Generate Data Table

image

5

Hi thank you but I am not using generate data table instead i am using Build Datatable

6

Can anyone help please :pray:

7

Hi @dipon1112000 , can you open and check in build datatable activity if there is any empty row? Click on x mark in first row…

8

Thank you for helping but I don’t have any empty row

9

Hi @dipon1112000. Can you share the xaml file to look into the issue?

10

Thank you for supporting but I cannot share the xaml as it’s in RDC but my input is identical to the example3

exaample3.txt (2.3 KB)

11

I tried but I am getting error as
Add Data Row Input arrey is longer than the number of columns in this data table

12

Can anyone suggest how to remove the first line from output as it’s coming as “,”

13

Hi @dipon1112000 . To remove only the first row, use remove data row where rowindex 0 means 1st row.
image
To remove rows with empty values for all columns, use filter datatable as below.
image
Hope it helps!

First line coming ,,,,,, in output
First line coming ,,,,,, in output
14

Thank you :pray: very much

1 Like
15

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