How to remove empty cells in datatable

Help Activities
, ,
1

I am getting data like below. Need to remove empty cells:

image
image272×209 2.92 KB

Expected output:
image
image289×131 3.17 KB

3

Hi @balanirmalkumar.s

Can you try this

The image depicts a flowchart in a software development environment showcasing steps for data table manipulation and output using a sequence of assignments, conditions, and message box display. (Captioned by AI)
The image depicts a flowchart in a software development environment showcasing steps for data table manipulation and output using a sequence of assignments, conditions, and message box display. (Captioned by AI)1178×911 40.3 KB

The image displays a UiPath workflow segment containing a condition and assignment block to verify and handle the presence of a Product Name within a data table's current row. (Captioned by AI)
The image displays a UiPath workflow segment containing a condition and assignment block to verify and handle the presence of a Product Name within a data table's current row. (Captioned by AI)1272×731 71.1 KB

The image shows a workflow schematic in UiPath, featuring a conditional logic where a non-empty check for 'Quantity' triggers the addition of a data row. (Captioned by AI)
The image shows a workflow schematic in UiPath, featuring a conditional logic where a non-empty check for 'Quantity' triggers the addition of a data row. (Captioned by AI)1261×707 69.6 KB

Output:

The image displays a workflow sequence in an automation tool, processing a data table and outputting the formatted text into a message box. (Captioned by AI)
The image displays a workflow sequence in an automation tool, processing a data table and outputting the formatted text into a message box. (Captioned by AI)1317×733 30.6 KB

Regards,

4

@balanirmalkumar.s,

It looks like your input table is a pivot table with filters and other settings.

Check the data source of the data and from there you can get the desired data easily than reworking on the data.

5

@balanirmalkumar.s

try to use below linq

Use build data table activity to create a new data table with respective column names.
after use assign activity, pass that new data table in to section and in value section you can ad below expression

(From row In dtInput.AsEnumerable()
Where Not String.IsNullOrWhiteSpace(row(“ProductName”).ToString)
Select dtOutput.Rows.Add(
row(“ProductName”).ToString.Trim,
dtInput.Rows(dtInput.Rows.IndexOf(row) + 1)(“Quantity”).ToString.Trim
)).CopyToDataTable()

after that you can use wirte range activity to write your data in excel or you can use that data table in your flow

An image showcasing a workflow automation designer where Excel data is read, filtered, processed, and then outputted to another sheet. (Captioned by AI)
An image showcasing a workflow automation designer where Excel data is read, filtered, processed, and then outputted to another sheet. (Captioned by AI)970×597 25.5 KB

output

image
image215×155 2.46 KB

Please mark it as solution, if you find it helpful

Happy automation!!