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
Solved! Go to Solution.
@gmamtani One way of doing this, use a select tool to remove the fields you don't want in the output result
Thanks @binuacs , Just one question, while applying the tiles macro, how did you put the count for number of tiles?
Thanks for the help :)
Regards
G
@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