BODS - Pivot Transformation issues

195 Views Last edit Apr 15, 2020 at 08:48 AM 5 rev

Hi Gurus,

I am trying to download FF data from my local system.Data looks like below

Country 01/01/20 01/02/20........................4/13/20

X 4 0 400

Y 0 0 200

Data is updated to till date everyday in the source level.Dates are with datatype int the source end.So I need to convert the columns(date) as rows. As I am thinking to schedule it I can't add manually the current date to the transformation.

Werner Dähn Please provide me inputs.

Thanks in advance,

Kavin