Filter Output based on certain criteria

[JJ747]

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.

[flying008]

Hi, @JJ747 

Just for you like result ?

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.

[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!

[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 · Accepted solution]

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