Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Adding more rows to column field names

Mwatts23
8 - Asteroid

Hi,

I would like to seek your help regarding adding more rows in the column field names.

I was exploring the Cross Tab tool but it is not working for me in stacking 3 fields as column names.

Below is the screenshot of the sample data and the expected output. I also attached the xlsx file for reference.

 

Mwatts23_0-1666375582540.png

 

 Please let me know if you have any clarifications on my query. Thank you.

 

Best regards,

Michael

 

10 REPLIES 10
bkurt
8 - Asteroid

You can either concatenate the string values or you can create rows and add them with a join tool. I think the file in the attachment should help you out.

Mwatts23
8 - Asteroid

Hi @bkurt ,

 

Thank you so much for the quick response. Is it possible to add the "Year" next to the Account ID? Like the one in my desired output on top. 

 

Best regards,

Michael

bkurt
8 - Asteroid

Hi @Mwatts23 ,

 

You're welcome. I added a version below that gives the values as you require.

If it is what you want, I would be very happy if you gave me my first solution badge :).

 

Best regards,

Bora

Mwatts23
8 - Asteroid

Hi Bora,

 

WoW! Thank you so much! this helps a lot.

I hope you can clarify, for example, I have a 100,000 rows do I still have to keep the same N number in both Sample Type Tool?

May I know what is the purpose of the Sample Type in the workflow?

Mwatts23_0-1666385956450.png

Best regards,

Michael

bkurt
8 - Asteroid

Hi Michael,

 

The use of the sample tool was to cut out the part after "expected output below" that was in the excel you provided.

You can leave it out other files.

If your file has a lot of duplicates, you might want to replace the second sample tool with a unique tool.

 

Kind regards,

Bora

binuacs
21 - Polaris

@Mwatts23 One way of doing this

 

binuacs_0-1666387381326.png

 

Mwatts23
8 - Asteroid

So, the First Sample tool that has N=6, I can just leave as it is even I have a thousands of rows?

If I have a lot of duplicate Account Ids, will that affect the first Sample tool if I don't use a unique tool?

 

Thank you for the information you are sharing Bora, this is super helpful.

 

Best regards,

Michael

bkurt
8 - Asteroid

You should not leave the sample tools in. Those were only necessary in the excel file you delivered earlier.

Mwatts23
8 - Asteroid

Thank you @binuacs for sharing your workflow. This is very useful as well.

 

Best regards,

Michael

Labels