Transpose tool

Question

Hi All,

Im struggling to get the transpose tool to work as i need it to. so i must doing something wrong in the settings.

I currently have this dataset, and i wanted to change it from its current layout to horizontal and then join it to a larger dataset using the file name.

Can anyone assist?

I want the cost category

Thanks

Capture.PNG

ChrisTX · Answer

Sheet 1 contains the fields

COST CATEGORY
  LEAKAGE
  FileName

Only one of those fields, FileName, is on Sheet 2

I guess the input is still missing a tab for "source file 2" that you want to join to, to get Sheet 2?

Can you provide all of the input data in an Excel file?

afv2688 · Answer

Hello @moshood ,

Is this ok for you?:

Regards

cross tab.yxmd

moshood · Answer

Hi All,

Thanks for the prompt response.

I want to convert sheet 1 to sheet 2.

Thanks again

Alteryx query.xlsx