• State Not Answered
  • +2 person also asked this people also asked this
  • Replies 13 replies
  • Subscribers 10 subscribers
  • Views 9848 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Trying to update CDT using Parse Excel to CDT smart service

soujanyac0001
A Score Level 1

I am trying to update my cdt using parse excel, but i am not getting any cdt values.

The inputs i have given are:

1.The excel doc from KC

2. cdt- i have given ={'type!{urn:com:appian:types:ABC}ABC_Employee'()}

The other fields i havent changed anything. Should we mention all the fields of the cdt in the excel sheet.

Could someone assist me with this.parseExcelData.xlsx

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    Hi Soujanya ,

    1) As "Parse Excel to CDT" parses the data for which the CDT fields are matched with the column name in the excel.
    2) You need to mention which sheet number you want to parse into cdt.
    3) Where it says row number to read from in data tab inputs, the row should be the first row with data that actually matches the CDT
    fields, not the one with the titles of the CDT fields .
    4) provide the CDT, in which you want to parse the data.

    Thanks
Reply
  • 0
    Certified Senior Developer
    Hi Soujanya ,

    1) As "Parse Excel to CDT" parses the data for which the CDT fields are matched with the column name in the excel.
    2) You need to mention which sheet number you want to parse into cdt.
    3) Where it says row number to read from in data tab inputs, the row should be the first row with data that actually matches the CDT
    fields, not the one with the titles of the CDT fields .
    4) provide the CDT, in which you want to parse the data.

    Thanks
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.