Loop through columns

Hi everyone,

I have attached a sample excel file that contains emails and titles as columns. I want to break this down to only display two records each which can be done with the recordID tool and the filter tool. The issue is that when I output them to only display two records each, they show all the columns in the dataset. How do I make it so that only the columns with a value for each email appears? Any help would be greatly appreciated.

Thanks!

outputexample2.PNG

Workflow

Accepted answers

AmeliaG

Hi @Chirag_Gandhi07,

I've attachted the workflow and batch macro to work with 11.0.

Let me know how it goes!

Amelia

testexample_agedits.yxmd

batch_macro.yxmc

All comments

AmeliaG

Hi @Chirag_Gandhi07,

It looks like it would be great to add a Transpose and Filter tool. First, Transpose the data with the 'Email' field as the Key and then all other columns as the Data. Then, use the 'Filter' tool to filter out values where the cell is blank or null. The resultant will be one email column, one title column and one value column.

Does this meet your needs?

Thanks!

Amelia

Chirag_Gandhi07

@AmeliaG Thanks for your response. I have attached a sample workflow and excel file. So if I output only record 1, I want the only column to be displayed Title 2 because that column has a value for test1@test.com. Not sure how to go about doing this though.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703