Need to write data from Rowise data into a single line data to a data table

[manjesh_kumar]

Hi,
I have a workflow which extracts data from OCR Engine and it is giving the data (9 Values) in the following format.

I need to write the same as a single row in this following data table.

This is how my workflow looks.

Appreciate your feedback on how I can achieve this.

Regards,
Manjesh

[THIRU_NANI (NaNi)]

Hey!

Use add data row

In the array of row mention the item names like this

{Airlines,Invoice_Date,Inv_Tkt_Number}

So on…

Note:

The position of the columns which is there in the temp dt should match with the position of the values which you’re getting from array

Regards,
NaNi

[manjesh_kumar]

Hello Thiru,

I did not get you.

I am looping through My_Fields and I get only 1 value at a time i.e.

item.Name=“Airlines” and item.value=“xxxxx” , I have to insert item.value=“xxxxx” into dt_FinalTable column Airlines and so on.

Share some screen shots for easy reference.

[THIRU_NANI (NaNi)]

Hey!

So, The item Value you’re getting the data right!

For each iteration are you getting only one value?

i mean to say in first iteration are you getting only Airlines as a name with value or You’re getting all the fields in one iteration (Airlines,InvoiceDate,InvTktNumber…)?

If your getting all the items

take multiple assign activity and pass the values like this

Airlines=Item.Value.ToString
Invoice_Date=Item.Value.ToString
.
.
.
.

Then Use add data row and pass the variables in array of row

Reference:

Regards,
NaNi

[manjesh_kumar]

Hi Thiru,

My aplogies, I am getting all the values in on go in My_Fields so I did the following and it works however this does not look like a good solution, if the number of fields increases then I have to manually update it.

Right now this works if there is a better solution let me know.

Thank you very much for the support.

[THIRU_NANI (NaNi)]

Hello!

100th solution

Cheers,
NaNi