Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Entries Repetition

PedroRR
5 - Atom

Hi, 

 

I am currently dealing with a dataset with 1000 entries, divided in 6 columns. I need to make a calculation in which every entrie is divided by twelve and multiplied by each period of the year (1 - 12). The problem is that the table data is not assigned to any period at all. Therefore, I thought that replicating the table entries 12 times and adding to each entrie a value from 1 to 12 should resolve this issue. Is it possible to make something like that on AlteryX ?

 

I'm new to the AlteryX, if someone in the community has other approach for this problem, feel freely to suggest. 

1 REPLY 1
apathetichell
19 - Altair

post some sample data - with what you have and what you want. are they currently in record order? Ie there is a record id 1 which corresponds to month 1?

Labels