Filter Output based on certain criteria

Hello Users - I have a requirement where my input file has some fields which has the earning codes and earning amount and some field has only earning code

so I wanna filter those columns which has only earning codes and the output of the file should have only columns earning codes and earning amount.

Earnings_Dedns.xlsx

Workflow

Output

Expression

Accepted answers

Qiu

@flying008
I think I can understand the point now.
Thank you very much.

All comments

flying008

Hi, @JJ747

Just for you like result ?

录制_2022_06_23_10_49_03_190.gif

Input

Earnings Reference 1	Earnings Amount 1	Earnings Reference 2	Earnings Amount 2	Earnings Reference 3	Earning Reference 4	Earning Amount 4
A1	100	B1	200	C1	D1	300
A1	101	B1	201	C1	D1	300
A1	102	B1	202	C1	D1	300
A1	103	B1	203	C1	D1	300
A1	103	B1	203	C1	D1	300


Output

Earnings Reference 1	Earnings Amount 1	Earnings Reference 2	Earnings Amount 2	Earning Reference 4	Earning Amount 4
A1	100	B1	200	D1	300
A1	101	B1	201	D1	300
A1	102	B1	202	D1	300
A1	103	B1	203	D1	300
A1	103	B1	203	D1	300

Qiu

@JJ747
I take the post fix such as 1, 2, 3 and count. Any the ones are not having same count will be ones to filter out.

0623-JJ747.yxmd

Qiu

@flying008
More shorter than mine. good one.
Can you also upload your flow so I can learn a bit?

grazitti_sapna

Hi @JJ747, another way of solving this problem.

I hope this helps!

Thanks!

JJ747_workflow.yxmd

flying008

Hi, @Qiu

Dear, I can't upload files because of security policy. and the key step in this workflow is to use a multi-Row formula to filter out fields row that only have Codes but no Amounts in field info. Hope this help for you, so sorry !

Qiu

@flying008
I think I can understand the point now.
Thank you very much.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703