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.

How to create table for each row of data and then join the tables together

ChloeZhao0122
7 - Meteor

Hi, i have an input excel files with multiple rows of data and i want to create table(using the table tool) for each row of data and then join them together. How can i achieve that? 

 

I am thinking to use macro but i have no idea how to achieve it

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@ChloeZhao0122 

What will be rendering tool final output format?

ChloeZhao0122
7 - Meteor

basically in the final output,  in between some rows there should be blank rows and the blank rows should not be squeezed. 

If i just do table for the whole rows of data and render, then the blank rows are sequeezed. That's why i want to create table for each row of data, join them, insert report text with space in between tables and then render output

Qiu
21 - Polaris
21 - Polaris

@ChloeZhao0122  
Is this ok?

Capture512.PNGCapture513.PNG

 

 

Labels