Summarize data

[hari1]

Hi,

I am very new to alteryx and would like to have your help in solving a problem.

I have 2 files, lets name as F1 & F2.

Both files have bunch of tables. I need to take data from one table of F1 and paste in a table of F2.

The data being copied from table of F1 is numbers by month and hence the summary being prepared in F2 will always refer to next column for every month.

Any ideas?

Thanks in advance.

Hari

[jdunkerley79]

Could you post some mocked data so we can advise.

There are many ways to do something like you describe but depends on the shape of the data which way might be 'best'

[hari1]

Hi,

Sorry that I generalized it too much.

I have uploaded the files herewith and the goal is to get June data in File 2 (mentioned in yellow).

Thanks,

Hari

[jdunkerley79 · Accepted solution]

Have had a quick go based on what you described

Basically, I convert to a row based table and keep newest total row for each phase from F1

This is then joined to F2 as a row based tabled

and then convert back to column based.

You could do it more simply by just joining but then you would need to amend every month. This approach should just keep working...

 

[hari1]

Thanks for your help Magnetar..

I will explore from here..

Hari