Skip to main content
  • EN

I have two things that I am trying to accomplish with the current feature/attributes that I have joined. For each row of data, I need to write out 5 new rows. Also, in the new rows, some of the column values are the column names of the input feature.

Here is an example: (Attribute Name: Attribute Value)

input: ASSETNUM: 12345, VLVCOND:Good, TRNSOPEN:10, OPENDRTN: Clockwise, STRUCTUR:No, SURCOVER: Blue, INSPECTOR:Joe Smith

Output: ASSETNUM:12345, METERNAME:VLVCOND, OBSERVATION:Good, INSPECTOR:Joe Smith

ASSETNUM:12345, METERNAME:TRNSOPEN, OBSERVATION:10, INSPECTOR:Joe Smith

ASSETNUM:12345, METERNAME:OPENDRTN,OBSERVATION:Clockwise, INSPECTOR:Joe Smith

ASSETNUM:12345, METERNAME:STRUCTUR, OBSERVATION:No, INSPECTOR:Joe Smith

ASSETNUM:12345, METERNAME:SURCOVER, OBSERVATION:Blue, INSPECTOR:Joe Smith

 

Any help would be greatly appreciated.

Thanks.

You should be able to do this with an AttributeExploder

 

Is your input text as per the example, or do you have a feature that has attributes ASSETNUM, VLVCOND etc. like this

Capture

You should be able to do this with an AttributeExploder

 

Is your input text as per the example, or do you have a feature that has attributes ASSETNUM, VLVCOND etc. like this

Capture

The input is a feature that has attributes like you have it shown above.

This is the sort of workflow you would need

Capture

This is the sort of workflow you would need

Capture

That worked perfectly. Thank you so much for your help.

Reply


Community Stats

30,177
Posts
114,554
Replies
37,842
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.