Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Generate rows based on number of bedrooms

jagjit_singh
8 - Asteroid

Hi,

 

I have the below property data and depending on the number of bedrooms like to create additional Prop Code with suffix ( A, B, C....)

 

Prop Code

Bedrooms

Repair Type

4041

3

HSE

4042

5

HSE

 

Desired Result as in the below table

 

Prop Code

Type

Repair Type

Unit Description

Bedrooms

4041

Scheme

HSE

Cost Ctr-Share Hse /

3

4041A

Property

RM

Room 1 /

1

4041B

Property

RM

Room 2 /

1

4041C

Property

RM

Room 3 /

1

4042

Scheme

HSE

Cost Ctr-Share Hse /

5

4042A

Property

RM

Room 1 /

1

4042B

Property

RM

Room 2 /

1

4042C

Property

RM

Room 3 /

1

4042D

Property

RM

Room 4 /

1

4042E

Property

RM

Room 5 /

1

 

 

Thanks

Jag

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@jagjit_singh,

 

Sorry, I'm multi-tasking.... her is a solution.  It generates rows for the bedrooms and then replaces #'s with letters.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
andre347
10 - Fireball

Hi @jagjit_singh

 

Please see attached a solution from my side.

 

Let me know if that worked for you

 

Screen Shot 2017-09-19 at 13.44.11.png

 

 

Labels