Trying to update CDT using Parse Excel to CDT smart service

soujanyac0001 : Can you please provide an excel sheet that you are trying .

I have attached in the question Venkatesh

I have attached in the question Venkatesh

soujanyac0001: I am able to read the data from excel file and Please find below attachments.

PF screen an able to read data from excel .

Below is the CDT's:

PF Excel which i am reading and i have given one sample record .

2158.parseExcelData.xlsx

Can you please check the below points:

• Did you saved output in CDT Type process variable .
• Can you please configure CDT input as PV [Sometimes it wont read].

 

 

Thanks!!

You mean the returnCdt right...i have saved it into cdt type process variable only..not knowing why it is not working..Is it mandatory that all the fields of the cdt must be present in excel sheet. And does it populate nested cdt data?

soujanyac0001 : Please find below comments:
1. It's not mandatory that all the fields of the CDT must be present in excel sheet.
2. I am not sure whether it will work for nested CDT Or NOT.


Thanks!!