Need help in Transforming Dimensions

[#1]

Dear,

Community.

Scenario:

How can i use cross table function to make 4 dimensions as One Dimension. and similarly next four dimensions as another dimension.

please see the attach files.

what would be the best approch to full fill the requirment.

[whiteline · Accepted solution]

Hi.

Just rearrange your fields in a load statement and use two separate loads:

(ID is used as a key to connect the tables)

Crosstable([Consultancy], [Consultancy Value], 9)

LOAD

  rowno() as ID,

  Depatment,

  Designation,

  [Hiring Target],

  [YTD Offers Extended],

  [Rejected Offers],

  Drops,

  [Pending Offers],

  [Outstanding Offers],

  [Consultancy A],

  [Consultancy B],

  [Consultancy C],

  [Consultancy D]

FROM

(ooxml, embedded labels, table is Data);

Crosstable([In Processing Consultancy],  [In Processing Consultancy Value], 1)

LOAD

  rowno() as ID,

  [In Processing Consultancy A],

  [In Processing Consultancy B],

  [In Processing Consultancy C],

  [In Processing Consultancy D],

FROM

(ooxml, embedded labels, table is Data);

[#3]

Dear,

Thanks it works like a charm.

Thanks,

Mukram.