Transpose execl using LINQ query

Help Activities
, , , , , , , , , , , , , ,
1

Hi,

I don’t want to use any activity. Want to achieve it using LINQ.
Any idea?

Thanks in advance!

2

Have a look for starting

1 Like
3

Hi @ppr,

Thanks for sharing it.
It’s not what I’m trying to do.
I want to try simple transpose using LINQ.

4

@Ray_Sha1
Yes as menioned it is introducing on the main building blocks like

  • setting up dynamic the columnstructure
  • collecting values and tanspose it

Maybe you share some more detauils (requirement, sample data) with us. Based on this we can give you a more case related help

5

Hi @ppr,

For example- in my excel sheet, I have

A B C

    1. 1
    1. 2
    1. 3

I want to transpose it.
I’ve achieve it using activities and it’s takes a lot of time for big reports.
Using LINQ is there a way to achieve this?

Thanks in advance!

6

please in input, expected output pattern. Thanks

7

Hi @ppr

The input sheet is

IMG_20210610_201225
IMG_20210610_2012251300×2312 1.2 MB

The output sheet must look like

IMG_20210610_201314
IMG_20210610_2013142600×4624 3.07 MB

Thanks!

8

@Ray_Sha1
Variables:

grafik
grafik749×125 20 KB

we are preparing the target Column structure dynamicly as following:
grafik
grafik

then we can execute follwoing LINQ:
grafik

(From x In Enumerable.Range(0,dtData.Columns.Count)
Let ra = dtData.AsEnumerable.Select(Function (d) d(x)).ToArray
Select dtDataResult.Rows.Add(ra)).CopyToDataTable

Result:
grafik

2 Likes
9

Hi @ppr,
Getting a lot of errors.

Is it possible to share the xaml?

Thanks in advance!

10

find starter help here:
Transpose_Demo_LINQ.xaml (8.9 KB)

its better to tell us which errors you got, as we can help on details

11

The shared xaml is not similar to the screenshot.
Following the screenshot, getting error like- assign- input array is longer than the number of columns.

This is what I’m Facing now.

Thanks

12

check from above on how the columns structre is set up dynamicly.
exception comes from a mismatch of available datacolumns and added values from the add datarow

I updated XAML above, was copying another case but is now correct one

13

@ppr thank you.
Works well

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.