AssignCol Value without Loop

[Qadar]

How to assign a Column value as IssueKey.CustomFields(“Col Name”).Values(0)
without using for each dt
assing a column value directly to a dt at the end append the dt to an existing excel

I want to update this CURRENCY col = IssueKey.CustomFields(“Project Name”).Values(0)

[Anil_G (Anil Gorthi)]

@Qadar

can you be more clear please..do you have a dt and you want to update only first or last row? and then append to excel?

cheers

[Qadar]

Assign: Expression Activity type ‘VisualBasicReference`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

[MohammedShabbir (shabbir.qs)]

Hi @Qadar

This Error is due to the Incorrect Double Quotes used, Re-Type the Double Quotes in the Expression (Not Copy Paste) and check :
dt.rows(0)("CURRENCY") = IssueKey.CustomFields("CURRENCY").Values(0)

[Anil_G (Anil Gorthi)]

@Qadar

use this double quote " and not this “

cheers

[sayali.p (Sayali Patil)]

@Qadar

In detailed →

By Assuming:

• Your DataTable name → dt
• It already has at least 1 row
• Column name → CURRENCY

Assign activity / Invoke Code (VB.NET)

dt.Rows(0)(“CURRENCY”) = IssueKey.CustomFields(“Project Name”).Values(0).ToString