@supermanPunch File input as below.
inputp.xlsx (16.2 KB)
input2.xlsx (14.5 KB)
@fairymemay , I think maybe you have removed or Edited a Post which consisted of the Logic or Condition to apply for the new Columns added.
Could you provide the condition to apply for new Columns again ?
@supermanPunch After match with condition (old & new)
Condition lasted as below.
If column Type = Cash or Credit → I want to check data in column Account No. have data or not?
-
Case 1 Column Type = Cash or Credit and column Account No. have data) and column Check Name = True —> Pass data to Output T&C
-
Case 2 Column Type = Cash or Credit and column Account No. have data but column Check Name = False , I want check column Check Name2 if = True ----> Pass data to Output T&C
-
Case3 Column Type = Cash or Credit but column Account No. don’t have data —> Pass data to output Voucher
Thank you.
@fairymemay , There needs to be a Further Look into the Output needed.
Below is the Output after Previous Conditions are performed.
Output T&C.xlsx (59.8 KB)
To remove any further confusions, Can you modify this Output file and provide us the Output after applying the Last Condition you described in the above post ?
@supermanPunch In sheet month (type Cash) please delete column Type Normal , type Special.
or you can use file config for choose column that show in file output (for modify in future)
- Move row that column Cust Name = Oliver.
Because type = Credit but column Account No. not have data —> Move to file Output Voucher in sheet Jan_Spcl
File output T&C after modify with new condition as below.
Output T&C (2).xlsx (56.7 KB)
Thank you
Hi @fairymemay ,
Can you confirm on the below Output files.
Output T&C.xlsx (55.9 KB)
Output Voucher.xlsx (36.8 KB)
Let us know if it is not the expected outputs.
I want read by sequence (up to down file)
then sheetname in file Output T&C sheet as below.
and sheet name in Output Voucher in order as below.
In file Output T&C in sheet Dec and sheet Mar.
It shouldn’t have type credit
File Output T&C Sheet Summary TR order from sheet as below.
In file Output Voucher , although original data = Cash , Credit but If write in File output Voucher → change type to Voucher.
File output after update as below.
Output Voucher (2).xlsx (37.0 KB)
Output T&C (3).xlsx (56.8 KB)
Thank you.
@fairymemay , According to what condition we need to read the files in Sequence ?
In the Input folder the arrangement is as below :
@supermanPunch ah, okay
If I arrangement correct , I think output that ead the files in Sequence correct.
Hi @fairymemay ,
Check below the Updated workflow. It should be as your expected output.
Filter Excel.zip (120.7 KB)
@supermanPunch In file Output T&C sheet Summary T, Can it be made like this?
@fairymemay , For that we would need additional External Packages to be added if we are doing it dynamically or need to use Excel.Interop operations or VBA.
But if we are to keep the Template Updated to apply the Same format for all rows then the same can be achieved, although the format will be applied to all the rows.
Replace the Template.xlsx in Template folder with the below file and Check the Output.
Template.xlsx (47.4 KB)
@supermanPunch Thank you for your support me.