Column Filtering Help needed

HI All,
Need little guidance on how to proceed with the below problem.

I have uploaded the image.
There are multiple columns as shown.i.e. Col0 ,Col1…

Need to filter out in a specific way based on code.
under Col5, there is code AA.
So i will filter out all the values in that column (excluding 0 and blanks) along with other column
So first ouput should look like (A5 to F till end… excluding 0 and blanks in F)
Then next iteration wll be value next to AA, i.e. BB.
Second output will be A5 to G till end…excluding F column and 0 and blanks)
then combining first and second output .

I tried using loop and all. But cant figure out to how to extract this properly.
I tried using multiple excel readers, to get the codes AA ,BB separately, then rest of table seperately. Then used loop to search AA and take out the rows but was unsuccessful.

Please suggest a better approach.

Hi there @nd1992,

can you provide input data and expected output?


Hi @ipazin Thanks for the reply. I was able to figure out finally. Almost finished the workflow.
Wouldnt be able to share the data since it is of client.

Will sample workflow once its done.

Although I do have one question … I am facing the Exponent issue in the CSV writer as output.
I tried all the solutions mentioned in this forum i.e. Round double node, Java Snippet ,also disabling scientific notations in CSV Writer options. But it still keeps coming.
Any suggestions on how to solve it?

1 Like

Hi there @nd1992,

glad you managed to figure it out.

Regarding second question can you open up a new topic for it? Will be more visible and will keep our forum tidy. Tnx!


Hi @ipazin
Yes …Raised a new topic


1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.