topic Re: To generate row based on the cell value in Alteryx Designer Desktop Discussions

To generate row based on the cell value

Gsiva3 — Wed, 12 Apr 2023 12:34:43 GMT

Hi Team,

I have two columns in my input namely ColA & ColB. In ColB in one of the cell I have value as "Indication". So whenever I ma getting this word indication in the ColB I want a new row to be inserted above this "Indication" cell.

Please help me on this

Input
ColA	ColB
1	Section
2	Terms
3	Conditions
4	Queries
5	Indication

Output
ColA	ColB
1	Section
2	Terms
3	Conditions
4	Queries

5	Indication

Re: To generate row based on the cell value

Christina_H — Wed, 12 Apr 2023 12:40:49 GMT

Something like this?

Re: To generate row based on the cell value

BS_THE_ANALYST — Wed, 12 Apr 2023 12:41:17 GMT

@Gsiva3 one way:

Using the multi-row to identify the Indicator row. This allowed me to create a flag on that row, and all the rows below it.
Then filtering indicator row and below from the top section. Then adding a dummy row in. Then unioning everything together

Re: To generate row based on the cell value

PhilipMannering — Wed, 12 Apr 2023 12:42:55 GMT

Hey @Gsiva3

Something like this,

Re: To generate row based on the cell value

BS_THE_ANALYST — Wed, 12 Apr 2023 12:45:09 GMT

@PhilipMannering nice. I've never used an IF statement inside the generate rows tool. That's really cool.

Re: To generate row based on the cell value

PhilipMannering — Wed, 12 Apr 2023 12:46:14 GMT

Yeah, it works surprisingly well.