Adding data

Question

Hi I am new to Alteryx. I have a dataset which has  ID, Year and month. Every ID has data for several month. I would like to add all the 12 months to the dataset and wherever the data is not present for that particular ID in that month, that month should be null. For example Suppose There is an ID number 123 and it has data for month-2,4,6. I want to modify the dataset so that record 123 has data for all 12 months and except for 2,4,6 remaining will be null. So for each ID there should be 12 rows.

Can someone help me with this please.

soccertil1108 · Answer

@atcodedog05  @Ivaturi_Vighnesh  I saw a solution from another direction. Adding missing columns rather than missing row. Thus Cross Tab to multiple columns then Transpose back again. Just another suggestion to consider.

Adding Data.yxmd

Ivaturi_Vighnesh · Answer

Hey Thankyou so much. It worked

atcodedog05 · Answer

Hi @Ivaturi_Vighnesh

Here is how you can do it.

Workflow:

I have added explanation for each step in the annotations. Let me know if you have questions.

Hope this helps : )

Months.yxmd