Solved

ETL Api

  • 20 March 2023
  • 4 replies
  • 80 views

Badge

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.

 

 

icon

Best answer by ebay 31 March 2023, 14:46

View original

4 replies

Userlevel 6
Badge +5

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

 

Badge

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

Userlevel 6
Badge +5

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!

Badge

Hello @Christian Hauggaard 

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

Best Regards

Reply