Add a row

[Shoyeb23]

I am struggling to add a new row or header in alteryx flow. The header I want -  20240716(yyyymmdd), 2100, Stale BYPASS, TRUE

Could some one help?

[KGT]

You can rename headers through either the select or dynamic rename tools (and many others, but one of these will be your solution). Dynamic Rename has lots of options including taking headers from first row.

The option in Union to select which order the datasets are stacked is sometimes handy in this situation as well.

[Shoyeb23]

Thanks for your response. so by using dynamic I can add a row as shown in the  previous attachment?

The result I want,

1st row should be the header [ 20240716(yyyymmdd), 2100, Stale BYPASS, TRUE ]

2nd row should be the regular field [ Pricing ID, Hierarchy, PTG, Price Type, and other]

[Bren_Spill2 · Accepted solution]

@Shoyeb23 - if you are trying to add the data as shown, use a text input tool

[LindonB · Accepted solution]

Yeah, as mentioned previously, you can use dynamic rename. Here's how to configure it.

Create a text input for your new field names:

Then use the Dynamic Input tool as follows:

Hope that helps!

[Shoyeb23]

Thank you so much, I believe that will work.

[Bren_Spill2]

Great!