Alteryx Designer Desktop Discussions

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

Heading Need to Fill Columns

Athilingam_S
7 - Meteor

HI 

 

Could you please help me the below in Alteryx

 

Athilingam_S_1-1629995777177.png

 

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Athilingam_S 

 

Can you provide a sample input file.

Athilingam_S
7 - Meteor

Hi

 

Find the attached file for your information

atcodedog05
22 - Nova
22 - Nova

Hi @Athilingam_S 

 

You can use multi-row formula tool to fill data.

 

Workflow:

atcodedog05_0-1629996810237.png

 

1. Configure input tool to first row contains data.

atcodedog05_0-1629996915022.png

 

2. Use multi-row formula tool to fill data.

3. Keep rows where F2 is not null

4. Using dynamic rename to take column name from first row.

 

Hope this helps : )

Athilingam_S
7 - Meteor

It's Really helped Thanks a lot 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Athilingam_S 

Cheers and have a nice day!

Labels