LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: a7n

Hi Guys/Girls

Appreciate if anyone can help me figure out how the below can be done. I am completely out of ideas :-/

Current data
Product_Code ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 Amount Code Description START_DATE_ACTIVE END_DATE_ACTIVE
ACME1234 Basic 1 High Metro NULL 123 112ZA Acme Basic High Speed Metro 1 1/02/2016 NULL
ACME5678 Standard 2 Medium Regional Cluster 1234 XYZ1 Acme Standard Medium Regional 2 1/02/2016 15/05/2018

How i want it
Product_Code ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 NewCol1 NewCol2 START_DATE_ACTIVE END_DATE_ACTIVE
ACME1234 Basic 1 High Metro NULL Amount 123 1/02/2016 NULL
ACME1234 Basic 1 High Metro NULL Code 112ZA 1/02/2016 NULL
ACME1234 Basic 1 High Metro NULL Description Acme Basic High Speed Metro 1 1/02/2016 NULL
ACME5678 Standard 2 Medium Regional Cluster Amount 1234 1/02/2016 15/05/2018
ACME5678 Standard 2 Medium Regional Cluster Code XYZ1 1/02/2016 15/05/2018
ACME5678 Standard 2 Medium Regional Cluster Description Acme Standard Medium Regional 2 1/02/2016


LAE HELP.JPG

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

This type of operation is specifically what the "Names To Data" node was designed for.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: a7n

Originally posted by: stonysmith
					

This type of operation is specifically what the "Names To Data" node was designed for.



node:Pivot__Names_To_Data
bretype:core::Pivot - Names To Data
editor:sortkey=5afa68290a1060f3
input:@4c8fdfd712226f21/=Static_Data.40fe6c55598828e5
output:@4c93bf5c2ec21c56/=
prop:DataOutputField=NewCol1
prop:NameOutputField=NewCol2
prop:PivotFields=Amount,Code,Description
editor:XY=480,210
end:Pivot__Names_To_Data

node:Static_Data
bretype:core::Static Data
editor:sortkey=5afa674e60c8154a
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
Product_Code,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,Amount,Code,Description,START_DATE_ACTIVE,END_DATE_ACTIVE
ACME1234,Basic,1,High,Metro,NULL,123,112ZA,Acme Basic High Speed Metro 1,1/02/2016,NULL
ACME5678,Standard,2,Medium,Regional,Cluster,1234,XYZ1,Acme Standard Medium Regional 2,1/02/2016,15/05/2018
EOX
editor:XY=380,210
end:Static_Data


			

Thank you & much appreciated !