{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString, , ,CurrentRow(“Eligible”).ToString,CurrentRow(“Details”.ToString)}
new Object(){strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,nothing, nothing ,CurrentRow("Eligible").ToString,CurrentRow("Details").ToString}
we added following:
- new Object() - to force the datatype of the array
- filled up empty values with nothing
- we fixed the closing ) for CurrentRow(“Details”).ToString
- we ensured that
"
this type of double quote is used
Try like this @Sandhya_Gajare
{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,"","",CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}
Regards
Gokul
Hi @Sandhya_Gajare,
If you want blank entries you should make it like this.
{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,String.Empty,String.Empty,CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}
Regards
Ömer
Use this in your ArrayRow Fields
{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,"","",CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}
What you done is
CurrentRow(“Details”.ToString) instead of CurrentRow(“Details”).ToString
And not given “” for empty strings
Regards
Sudharsan
Hello @Sandhya_Gajare
As per the data that you have provided,
Your expression seems to be valid but there is an error in the expression CurrentRow(“Details”.ToString). Instead, use as below.
CurrentRow(“Details”).ToString
Thanks
In your query you made two mistakes
- CurrentRow(“Details”.ToString) instead of CurrentRow(“Details”).ToString
- You used only
,,
for the empty string, You must use""
ornothing
orEmpty.Tostring
Regards
gokul