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
4 replies
Subscribers
4 subscribers
Views
1487 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi, we have a use case to read excel and map it to our existing CDTs. The smart
nikhilh0001
over 11 years ago
Hi, we have a use case to read excel and map it to our existing CDTs. The smart service for reading Excel and mapping to CDT does not work if the CDT contains an array data type or nested CDT. As a test, I did the following:
1. The original CDT is in the form
ActualCDT
|_Integer (Multiple)
|_NestedActualCDT
|_Text (Multiple)
|_Date
2. Created a new CDT and brought the hierarchy of the nested CDT into the Top level ActualCDT:
ModifiedCDT
|_Integer
|_Text
|_Date
3. Using the Excel Smartservice, mapped the columns to the ModifiedCDT (which has no multiple valued data types)
4. Using a script task, directly stored ModifiedCDT to ActualCDT and mapped ModifiedCDT to NestedActualCDT
To my surprise, it automatically mapped all the data type fields exactly to the Actual CDT. Even when there were more than 1 data types of the same format, the mapping seems to have happened based on the name of the Field. i.e. Date1 was mapped to Date1; Date2 w...
OriginalPostID-75637
OriginalPostID-75637
Discussion posts and replies are publicly visible
Parents
0
nikhilh0001
over 11 years ago
hi Jorge, actually, although the question involves the smart service, its more to confirm the CDT behavior - storing the CDT directly into another versus storing individual field entities of CDTs into field entities of other CDT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
nikhilh0001
over 11 years ago
hi Jorge, actually, although the question involves the smart service, its more to confirm the CDT behavior - storing the CDT directly into another versus storing individual field entities of CDTs into field entities of other CDT.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data