Depending on the Number of Entries, Duplicate the IDs, Emails, and Mobile Numbers.

[caltang]

Data frame looks like this:

ID | Email | Mobile Number | Number of Entries

99 | Example@example.com | 00000000 | 4

Ideally, the expected output is:

99 | Example@example.com | 00000000 

99 | Example@example.com | 00000000 

99 | Example@example.com | 00000000 

99 | Example@example.com | 00000000 

Basically, duplicate the rows based on the number of entries with the dimensions being ID, Email, and Mobile Number.

Any pointers?

All help appreciated!

[MarqueeCrew]

@caltang ,

 play with the GENERATE ROWS tool. It does what you need. 

cheers,

 mark

[Qiu · Accepted solution]

@caltang 
Since you are asking, I will just give you a quick sample.

[caltang]

Massive thanks! I did what you did and it worked like a charm. I was wondering if transpose or arrange could do so as well - this is similar to a question asked in the designer core some time ago.

[caltang]

Thanks man! This works too.