I have file as attached.
Data09.xlsx (11.0 KB)
Sheet config (Set number column in file input) as below.
Sheet Config
I want to read sheet config for filter sheet input that column3 (type) = RE.
Sheet input
After filter I want write data in sheet output (write column2=Name , column3 = Type) as below.
Please guide me about it.
1 Like
Hey @fairymemay
I’m sorry, Unable to understand it clearly.
There is something you need to filter which is fine, do you want to filter based on the config sheet input ?
Please elaborate
Thanks
#nK
@Nithinkrishna New file as attached.
Data09.xlsx (13.8 KB)
Yes, I want to filter based on the config sheet.
From sheet config
Col_No = column number 1 (Column A in sheet input )
Col_Name = column number 2 (Column B in sheet input )
*I create file config because If I change name column —> Not error & easy for edit.
I want filter type (Column3, Column C) = RE. —> write data that match to file output
Sheet Input as below.
(Write data in Column1, Column A —> Name & Write data in Column2, Column B —> Type)
Sheet Output as below.
Please guide me about it.
1 Like
fairymemay:
olumn B in sheet
FilterExcelData_09012022_1517.zip (11.3 KB)
Please find the attached solution. Hope this will be useful.
Kindly check the logic if you can understand it. If not please let me know.
Thanks
#nK
@Nithinkrishna No, I want use column number instead of column name.
(Column Number 1 = Column A , Column Number 2 = Column B , Column Number 3 = Column C , …)
Please guide me about it.
1 Like
Hey @fairymemay
That requires a small change, which is done in the below attached zip.
FilterExcelDataByColNos_09012022_1517.zip (12.3 KB)
Hope this helps.
Thanks
#nK
1 Like
@Nithinkrishna I have question.
My File as attached.
File Input : Data09.xlsx (14.2 KB)
File output : output91.xlsx (9.5 KB)
File Report : Report.xlsx (8.8 KB)
If I add requirement as below.
If file input have more 2 sheet , I want read loop all sheet in file input (Except sheet config , invisible sheets) filter type = RE and write data in new file output and create name sheet follow input sheet.
File Input
Sheet Config as below.
I want map data addition in file output with File Report and write in file output.
Sheet Output as below.
It have 2 sheet (Follow input file)
Please guide me more about it.
1 Like
Hey @fairymemay
You need to just loop through the files,
Directory.GetFiles
will help you to get all the files from the input directory for processing
Loop that file collection (from Step1) using a for-each loop
Inside the for-each loop
just add the logic which we already built by replacing the hardcoded file path with the for-each loop item
Thanks
#nK
@Nithinkrishna I understand 1. But I don’t understand in 2,3.
Please guide me more.
Thank you
1 Like
FilterExcelDataByColNosForMultipleFiles_09012022_1517.zip (34.8 KB)
Here I have updated the code to handle multiple sheets.
You can customize it as required.
Hope this helps.
Thanks
#nK
@Nithinkrishna
Yes, But I don’t understand how to map data as below. (Map column Summary with Type)
I want map data addition in file output with File Report and write in file output.
Sheet Output as below.
Please guide me more about it.
File Input : Data09.xlsx (14.2 KB)
File output : output91.xlsx (9.5 KB)
File Report : Report.xlsx (8.8 KB)
1 Like
Hey @fairymemay
You need to just add summary column to the output right ?
Thanks
#nK
Please check the filter DT activity & add the extra column over there similar to how we added other columns
@Nithinkrishna In this right?
1 Like
@fairymemay
Yes, Perfect. You are in the right direction.
1 Like
system
(system)
Closed
January 14, 2022, 1:20pm
18
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.