Filtering Some Columns from the Excel Data and Removing the Leading Zeros

Help Studio
, ,
1

Hi team,
I have one problem to be solved using studio.
I have an excel file with my data source. I must prepare my data before loading to the Queue items. There are four scenarios to be considered.

  •      Filtering a customer name from “Customer” Column, filtering a month from the “Start Date” Column, filtering a Store number from “Store #” column and removing the leading Zeros (0s) from the “PO” column. I’ll repeat three more filterings by just changing the customer's name and store number.

Can anyone give me an idea on how to proceed?

Thanks a lot!

1 Like
2

Hi @Sisay_Dinku

what are the condition used for filtering. Can u share input file?

Regards

3

Hi @Suraj_B_Shetty
Thank you for your time. Here the sample data.
For example,
Source_Data.xlsx (14.3 KB)
I need PO #s for
CALISUN customer, for the month (start date) of April, and for the Store # 12

4

Hi @Sisay_Dinku

Check this workflow.
FilterMultipleColumn.xaml (6.9 KB)

Output
Source_Data.xlsx (15.4 KB)

If you want only PO number in the output then try this

image
image1049×363 13.2 KB

Hope this helps

1 Like
5

HI @Suraj_B_Shetty

Thanks you so much. That’s an excellent job. I have one thing missing. I wanted the PO # column’s leading zeros to be removed in the output file. Thanks a lot once more!

6

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