AnsweredAssumed Answered

Use a single survey entry to create multiple records in the same data table

Question asked by ahna.miller@driscolls.com_atlasdriscolls on Apr 10, 2020
Latest reply on Apr 14, 2020 by JTedrick-esristaff

I am looking to figure out a way I could possibly use a single survey entry to create multiple records in the same data table. For example, I have the following survey I am using to track the locations of assets moving from one location to another: 

 

Naturally this data comes into a very concise table indicating how much of an asset has moved from one location to another location 

ObjectID

Origin

Destination

Date

Quantity

Asset Year

1

1234

5678

3/29/2020 19:00

10000

2020

2

5678

6789

3/30/2020 19:00

1000

2020

3

12

6543

3/30/2020 19:00

1200

2020

 

 

I'm looking for a way I can manipulate this survey such that the data is entered as 2 different records- one for the incoming location and one for the outgoing location? This way when we export this data it is easier to create a pivot table tallying the number of assets in each locations.

Does anyone have any ideas of how this could be accomplished? I feel like I could potentially accomplish using something like repeats but am struggling to wrap my head around how to get this result

 

Transaction NumberLocationDateQuantityAsset Year
112343/29/2020 19:00-100002020
156783/29/2020 19:00+100002020
256783/30/2020 19:00-10002020
267893/30/2020 19:00+10002020

Outcomes