Csv file blank data

Help Studio
, ,
1

i have one csv file…in that file there are some employee data
in data there are some blank data
i want output like if employee data is blank the missing data with the header of the column name

2

Hi @purnima_mandan

Can ypu be clear if data is missing then what data you want? You need only column names? Where you have atleast one empty cell?

Cheers

3

if data is empty then make a new column name and writedown a header of the column name which column is blank

4

@purnima_mandan

Can you share a sample input and output… its little confusing to understand like this

Cheers

5

test.xlsx (16.1 KB)
sheet1 is inputdata
sheet2 is output
this is excel file but i want output in csv file

6

Hi,

How about the following sample?

image
image741×642 20.2 KB 

dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow({r(0),r(1),r(2),String.Join(",",dt.Columns.Cast(Of DataColumn).Where(Function(dc) String.IsNullOrEmpty(r(dc.ColumnName).ToString)).Select(Function(s) s.ColumnName))},False)).Where(Function(r) not String.IsNullOrEmpty(r("missingdata").ToString)).CopyToDataTable

Sample20221208-7.zip (14.4 KB)

Regards,