Make Extra Row Info Added to Proper Row?

[deepashah]

Hi all!

Please see attached sample workflow data. I am trying to make the Property ID match to its respective Tenant IDs and Tenant Names. However, if there is more than one result, I would want the results to be additional columns rather than additional rows. This way, all of the pertinent information is connected to the same ID.

Currently, the information is matching and being added as a new row; I believe I need to add a cross-tab somewhere, but I am unsure where. I already added cross-tabs to get the info in the initial text input tools.

Here's what I think the solution should look like - basically, all the info for that "ID" should be on the same row.

recordid	groupby	proprecordid	id	occupancytenantid1	tenantname1	occupancytenantid2	tenantname2
0	0.01	0.01	997106	retaillocation_401122	McDonalds	retaillocation_380490	Subway

[Luke_C · Accepted solution]

Hi @deepashah 

Would something like this work?

1. After joining, transpose to get the tenant ID and Name as rows.
2. Use the tile tool to assign orders by ID and field name (tenant ID/name)
3. Formula to update headers (1TenantName, 2TenantName, etc)
   1. I put the number first here so the ordering works out when we crosstab.
4. Cross tab to get your desired format
5. Dynamic rename to put the numbers at the end of the field name rather than the beginning.

[deepashah]

Hi @Luke_C , this works great! Thank you so much for your help, I appreciate it.