Filter, Transpose

[gmamtani]

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

G

[binu_acs]

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

[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

G

[binu_acs · Accepted solution]

@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