Skip to main content
To homepage To homepage
Solved

ETL Api

E
Contributor
Forum|alt.badge.img
  • ebay
  • Contributor
  • 26 replies

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.

 

 

Best answer by ebay

Hello @Christian Hauggaard 

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

Best Regards

View original
Did this topic help you find an answer to your question?

4 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+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

 

E
Contributor
Forum|alt.badge.img
  • ebay
  • Author
  • Contributor
  • 26 replies
  • March 23, 2023

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

Christian Hauggaard
Community Manager
Forum|alt.badge.img+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!

E
Contributor
Forum|alt.badge.img
  • ebay
  • Author
  • Contributor
  • 26 replies
  • Answer
  • March 31, 2023

Hello @Christian Hauggaard 

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

Best Regards

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings