Pivot tabel issue

[jduluc12]

Hi,

My data set looks like this

Main:

ID	Name
1	ABC
2	DEF
3	GHI
4	JKL

Aux:

ID	ID-1
1	4
2	3
3	2
4	1

Now I need to build a pivot like this:

ID	ID-1	Name
1	4	JKL
2	3	GHI
3	2	DEF
4	1	ABC

is it possible?

Thanks,

Jean

[prma7799]

Like this??

Main:

LOAD ID as IDD,

     Name

FROM

[279199.xlsx]

(ooxml, embedded labels, table is Sheet1);

Right join (Main)

Aux:

LOAD ID ,  

     [ID-1] as IDD

FROM

[279199.xlsx]

(ooxml, embedded labels, table is Sheet2);

[jduluc12]

Thanks P M but i can not change the load script.

[prma7799]

You want to achieve this in front end only ???

[jduluc12]

yes

[tresesco]

Try like:

Above( ID,-NoOfRows()+ 2*RowNo()-1)

Above( Name,-NoOfRows()+ 2*RowNo()-1)

[prma7799]

Hi tresesco‌,

Can you please explain that how you apply logic for this and how this functions will works.

Thanks & Regards

PM

[tresesco]

Above() with negative offset works like below(). Rest is simple math and row reference idea.