Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Analysis on scrap detail spreadsheet

8 - Asteroid

Attached the sample file, the following analyses have to be performed


Empty weighment of same Plate No

Usage of same Plate No for different types of Product Name

Select least empty weight of the same Plant No and applied with loaded weight (expected net weight)


I have done a preliminary analysis, unable to reduce the records while  joining with the other fields  or columns.


Please help to analyse the above requirements.


14 - Magnetar

I'm not sure what empty weightment is.


Hopefully this will get you started on your analysis. 



8 - Asteroid

thank you.


Empty weighment is the weighment of vehicle before it is loaded with any material.


May I know the options you selected in scrap?


Cross tab tool doesn't show the options in workflow.

14 - Magnetar

Here is the crosstab config. Also look at the config of the Tile tool.