[Newbie] Using StudioX to extract data from Excel into new reports

Help StudioX
1

image

Reference to the attached data in Excel. How do i churn these data using StudioX into reports (different worksheets) according to Sports/Fashion/Meal/Hobbies/Crafts ignoring the 0 zeros?
i.e
|Column 1 | Column 2 | Column 3 | Column 4|

|— | — | — | —|

|EID | Name | Sports | |

|469253 | Peter | 15 | |
|926072 | Rose | 2 | |
|258072 | Robin | 30 | |
|665358 | Mcgeth | 20 | |
| | | | |

|Column 1 | Column 2 | Column 3 | Column 4|

|— | — | — | —|
|EID | Name | Fashion | |
|128891 | Paul | 5 | |
|321244 | Mary | 50 | |
|926072 | Rose | 10 | |
| | | | |
| | | | |

2

@lohcx

Follow the steps

  1. Create a variable of type array…and assign {"Sports","Fashion",….}
  2. Use for loop with the array from step 1 as input
  3. Inside loop use filter datatable activity …and in columns use EID,Name and currentitem and in rows use currentitem and equals 0 and select remove
  4. Inside loop write the filtereddt to excel using erite range and sheetname can be currentitem again

Thsi will loop and filter data and write the data

Cheers

1 Like
3

Thanks for the reply Anil !
Can this be done using StudioX ?

4

@lohcx

Yes absolutely

Cheers

5

MVP Anil , thanks for confirming.
Pardon my amateurish questions, i am however uncertain of the exact steps to do it. Is there any simliar instances i may refer to?

I tried the following:

  1. Use Excel File
    1.1 Copy/Paste Range
    1.2 Set Variable Value (Value to save = “Sports”)
    1.3 Set Variable Value (Value to save = “Fashion”)

Ended up only copy n pasted the whole range of data :rofl:

6

@lohcx

This is what you need to do

image
image535×617 20.4 KB

image
image653×631 17.5 KB

NewBlankTask.zip (50.4 KB)

I would suggest you to do some trainings

cheers