I have a Input and desired output in the file attachment, please let me know what is the suitable tool in alteryx to get desired output.
Thanks in advance!
This is a very simple manipulation using the Cross-Tab tool.
I must add, however, that your input dataset is incorrect for reaching the desired output.
Store 1 only has data for 1/1/2023 and Store 2 only has data for 2/2/2023, whereas the output is a different aggregation here.
You just need to cross-tab the data.
Hi peterr_h
I tried with cross tab tool, but not getting correct output.
what needs to be selected in Method for aggregation?? please suggest.
@Chaitra_04 Agree with @peterr_h , maybe you can show us what you have been trying so far?
@Chaitra_04
Okay so firstly your input won't give you the output that you desire. The input needs to be changed to the following (rather than having Store 1 and Store 2 both having 2 of the same date, you'd need each store to have one of each date otherwise the desired output is not possible):
Store1
With this input dataset, you then connect a Cross-Tab tool with the following options:
Group By [Date]
Change Column Headers [Company ABC]
Values for New Columns [Amount]
Method for Aggregating Values: First
This will then give the following output:
Hope this makes sense?
Hi,
I tried your logic but not getting desired output. Please go through attached image.
Below attached image, please go through it.
