LAE

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

Originally posted by: Shalaka

How to convert/produce excel columns input into row formatted output? e.g below are the columns from the excel sheet which need to converted as row format putput using LAE nodes

Input

Plan NameaaaaaaaaaaaaaaaaaMonthly RentalaaaaaaaaaaaaOther Discounts
Plan 399aaaaaaaaaaaaaaaaaaa399aaaaaaaaaaaaaaaaaaaaaaa0


Output

Plan NameaaaaaaaaaaaaaPlan 399
Monthly Rentalaaaaaaaaa399
Other Discountsaaaaaaaa0

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

Originally posted by: dsc88dsc88

Hi, the "Pivot - Names To Data" node should be able to help you convert your inbound excel rows into the format you require within LAE.

If you copy the below example into your graph, this should give you the output you are looking for.


- - - - - - - - copy all text below this line - - - - - - - -

node:Pivot__Names_To_Data
bretype:core::Pivot - Names To Data
editor:sortkey=5395b05e5f3c1373
input:@4c8fdfd712226f21/=Static_Data.40fe6c55598828e5
output:@4c93bf5c2ec21c56/=
prop:PivotFields=*
editor:XY=490,480
end:Pivot__Names_To_Data

node:Static_Data
bretype:core::Static Data
editor:sortkey=5395afef2eaf2fe6
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
Plan_Name:string,Monthly_Rental:string,Other_Disco unts:string
Plan 399,399,0
EOX
editor:XY=390,480
end:Static_Data