Filter data (Excel)

Help Activities
, ,
24

@fairymemay ,

Without the New Condition added, we have the Output from the Previous Workflow that was provided. But the Output is not as the Expected one.

Can you Check if the below Output is the Correct one without the new Addition Filter ?
Output.xlsx (69.1 KB)

25

@supermanPunch If follow old requirement , output is correct.

But if in new requirement , it wrong.

26

@fairymemay , Do we have to add the New Condition after we apply the Old Condition ?

Or Remove the Old Condition and apply the New Condition ?

27

@supermanPunch combine new condition and old condition.

Step as below.

  1. filter new & old condition
  2. Create 2 file (Output T&C , Output Voucher) follow condition above.
28

@fairymemay After Applying the New filter after the Old Filter, we do not get any rows as Output, since there is no row in Dec Sheet with Column Status = Null and Column Type = Cash

image
image1118×192 16.3 KB

29

@supermanPunch Oh, sorry.

Update file input as below.
input.xlsx (15.5 KB)
input2.xlsx (14.2 KB)

If use new file sheet Dec.

  • Cash match 2 Rows (row 6 , 8)
30

@fairymemay ,

Even with these new Input files, the Output is only one row for Dec Sheet (Only Old Filter).

Output.xlsx (69.0 KB)

We do not get 2 rows, we get one row. And if we Apply the new Condition to this filtered row, we do not get the Expected output.

32

@supermanPunch I know cause.

Because approve date now = 25641231.

In requirement want Issue date < approve Date.
I change your code as below.

(Change > to < )

image
image1181×339 15.1 KB

33

@supermanPunch If change condition from > to < .

Output as below. —(old condition)
input.xlsx (15.4 KB)
Output.xlsx (52.8 KB)

I’m sorry , I forget date approve is according file Detail Send Data.

Please guide me for add new requirements.

34

@supermanPunch My data as attached.(file input , output , config , detail data)

Data.zip (141.8 KB)

Please guide me for add new requirement.

Thank you

35

@supermanPunch
I understand you busy.
But if you have freetime please guide me for add new requirement.

Thank you

36

Hi @fairymemay ,

The Below is the Input Excel for Dec Sheet.

image
image1107×157 15.1 KB

I cannot find the rows that satisfies the Condition : Column Status = Null and Column Type = Cash

The Expected Output doesn’t match the Output I am receiving after the First Filter (Old Requirement)

Find the Output file below after the First Requirement Condition is Performed :
Output.xlsx (80.8 KB)

39

@supermanPunch Your output (use old requirement) are correct.

Column Status = Null —> In column C = Null (blank)
Column Status = Complete —> In column L = Complete

I filter manual for show you as below. (old requirement)
inputp.xlsx (15.7 KB)

40

@supermanPunch I will waiting your for guide me about new requirement.

41

Hi @fairymemay ,

After Testing it with the Modified Workflow i.e after adding the new additional Conditions, I get the below Output. Could you Check if the Output is as Expected ?

Output T&C.xlsx (73.6 KB)
Output Voucher.xlsx (86.4 KB)

42

@supermanPunch File input update as below.

inputp.xlsx (16.2 KB)

Thank you

43

@fairymemay ,

It would be difficult for us to suggest or derive a Workflow/Solution if the requirement keeps adding up or gets changed.

Request you to provide us the final intended Inputs/Outputs.

If there are additional changes, we would have to alter the solution as well.

44

@supermanPunch Sorry , But It’s final requirement. (It won’t change after this.)

Please guide me for solve it.

45

@supermanPunch Sorry , But It’s final requirement. (It won’t change after this.)

remark : But If in future column input have add another column (add column but same condition) , I’ll edit it in file config instead.

Please guide me for solve it.

46

@fairymemay , Can you Provide us the Updated Input files, there are extra columns that we need to account for.

1 Like