LINQ QUERY.build datatable

Help Studio
1

Hi

I am trying to build third datatable with two datatables as source datatables.
But when i am running my code i am seeing can not assign error.

Pfa screenshot for codr
@ppr @NIVED_NAMBIAR @Palaniyappan

2

@Satish_Ch

Can you share the screenshot?

If your third table is not declared then use Assign activity and take the schema of the first two table for that write as below

dtThirdTable = dtSecondTable.Clone()

Now you can use the dtThirdTable

Hope this help you

Thanks

3

ensure a variable with name: dt_finalReport… is defined and initialized. The datatable has the three columns configured as you have implemented within the LINQ.

Kindly note: you are aware of that a cartesian product is specified with this LINQ

4

Could you help me write sumif formula directly with write cell activity