Skip to main content

Hi all,

Too many parameters in nasa api data available year and month. I changed their name via RSD file because  and have only one table like below;

 

 

I have to change this columns in this dataset from this 

 

station WS10_MAX201901 WS10_MAX201902 WS10_MAX201903 …..    WS10_MIN201901 WS10_MIN201902 WS10_MIN201903 …...

 

to this

 

station      MM.YYYY       WS_10_MAX         WS_10_MIN

 

 

How can I do it? I tried Custom Table Insert but doesnt work. I tried also Junk Dimension but I had to clone my dataset 12 time to be able to print  for example 12 months 2019 data consecutively.

 

 

Hi @ebay it seems like you might have to unpivot your data

Fortunately, we have a new TimeXtender Tuesday video explaining how to do this

 

Thanks. I solved this problem. It was about Xpath.

Great that the issue is resolved! Could you please elaborate a bit more on the solution? What specifically did you change regarding Xpath?

Many thanks!

Hello @Christian Hauggaard 

It was a JSON file and it merged into a single column by changing the schema.

Best Regards

Reply


Terms and ConditionsCookie settings