Filter, Transpose

Hi Alteryx Experts

I have a data please see the input. What I want in this

a) we need to remove the seller id.

b) the remaining fields name, domain, and seller type are specific to each company, and we need to create a long and flat file. Please see the output.

c) From the Seller type we don't want the Intermediary companies.

Can you please help me with this?

Thanks' in anticipation.

Regards

Output.xlsx

Input.xlsx

Transformation

Dynamic Processing

Accepted answers

binu_acs

@gmamtani you wanted to split them into 4 fields, so divide the total number of records by 4 and put that number in the tile to split

17480/4 = 4495

All comments

binu_acs

@gmamtani One way of doing this, use a select tool to remove the fields you don't want in the output result

Transpose_250923.yxzp

gmamtani

Thanks @binu_acs , Just one question, while applying the tiles macro, how did you put the count for number of tiles?

Thanks for the help

Regards

binu_acs

@gmamtani you wanted to split them into 4 fields, so divide the total number of records by 4 and put that number in the tile to split

17480/4 = 4495

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703