Drag and drop the “Excel file” card onto your StudioX workflow and select the Excel file you want to work with.
Add the “Delete columns” action card.
a. Specify the Excel file you want to modify.
b. Select the columns you want to delete by clicking on the column headers or by specifying column names.
Add the “Keep columns” action card.
a. Specify the Excel file you want to modify.
b. Select the columns you want to keep by clicking on the column headers or by specifying column names.
c. Enable the “Keep only selected columns” option.
Add the “Filter table” action card.
a. Specify the Excel file you want to modify.
b. Select the column you want to filter by clicking on the column header or by specifying the column name.
c. Specify the filter criteria, such as text, numbers, or dates, to filter the column.
d. Configure any additional filter options as needed.