how to insert a row that concatenates the two rows below it

[Mond]

hi, i am new to alteryx and trying to figure out the most efficient way to insert a new row that concatenates ONLY two rows of data below it. Something like this:

 

i have been finding articles on summarize or dynamic rows but those work on all the rows in the data... how do i limit this to using only the first 2 rows of the data and insert it b/w the header and that data?

[EKBS83 · Accepted solution]

Hi,

You could filter out the records which just have "date" as their value and then use two RegEx tools to rename the "start" and "end" records as "start date" and "end date".

The only issues I can see still remaining for you is that you have conflicting data types in these columns, as the sub-headings are strings and your data is date type - you will only be able to use your dates as strings.

Hope it helps!

Thanks

Ed