Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
4 subscribers
Views
1026 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
I have one CDT (excelDataCDT) with two coulmns "Name" and "Addres
nitinj
over 8 years ago
I have one CDT (excelDataCDT) with two coulmns "Name" and "Address". These are same header names in my excel sheet.
Input parameters of Smart service "Parse Excel Spreadsheet to CDT" are as follows:
cdt: =readexcelspreadsheettocdt(pv!excelDoc,1,pv!data)
excelDoc: =pv!excelDoc
sheetNumber: 1
(custom input variables)
Name: {saveInto: data.Name}
Address: {saveInto: data.Address}
Output Parameter of the smart service are:
Return CDT: data
Process Model Variables are:
data: excelDataCDT
excelDoc: excelSheet
After start the process model we are getting first row as blank. Please see the attached excel sheet and CDT data.
Please let us know, why the first row is not populating in CDT.
Note: To get excel sheet and screenshot, please extract attached .zip file
list.zip
OriginalPostID-162862
OriginalPostID-162862
Discussion posts and replies are publicly visible
0
hrishikeshd
over 8 years ago
It is due to the custom input variables added, you do not need these custom inputs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel