QUestion for transformation

Question

HI FOLKS,

I have some raw data in the below format

ID NAME year scenario month$ monthhc

1 ZY        2002   expense 100        1

I wish to do the below:

ID NAME 2022EXPENSEMONTH$ 2022EXPENSEmonthHC

1 ZY 100 1

i have more than 40 M rows with multiple scnearios

What is the most ideal way to acheive this?

DataNath · Answer

The '$' is replaced as it's a special character - you'd have to rename it after the cross tab I believe.

EDIT: @SouravKayal I've added a dynamic rename tool which solves this issue after the cross tab. Attached:

Transformation from raw data.yxmd

SouravKayal · Answer

@DataNath , thanks , trying this, it could work, although i am seeing the $ getting truncated, any reasons ?

DataNath · Answer

@SouravKayal if it's in table format like your latest reply then you can just use the bottom flow (attached). From your initial post it seemed like it was in a raw format which you would need to parse.

Transformation from raw data.yxmd