Alteryx designer

[Chaitra_04]

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!

[peterr_h]

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.

[Chaitra_04]

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.

[Qiu]

@Chaitra_04 
Agree with @peterr_h , maybe you can show us what you have been trying so far?

[peterr_h]

@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):

CompanyABC	Date	Amount
Store1	2023-01-01	123
Store1	2023-02-02	23
Store2	2023-01-01	34
Store2	2023-02-02	45

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:

Date	Store1	Store2
2023-01-01	123	34
2023-02-02	23	45

Hope this makes sense?

[Chaitra_04]

Hi,

I tried your logic but not getting desired output. Please go through attached image.

[Chaitra_04]

Hi

[Chaitra_04]

Below attached image, please go through it.