Solved

Transformation or Python Script?

P
Badge +1

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.

icon

Best answer by ebygomm 18 June 2021, 15:56

View original

4 replies

ebygomm
Rank
Userlevel 1
Badge +21

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

P
Badge +1

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.

ebygomm
Rank
Userlevel 1
Badge +21

This is the sort of workflow you would need

Capture

P
Badge +1

This is the sort of workflow you would need

Capture

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

Reply


Community Stats

28,724
Posts
109,517
Replies
36,562
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.