Skip to main content
To homepage To homepage
Solved

ETL Api

  • March 20, 2023
  • 4 replies
  • 96 views
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

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


Terms and ConditionsCookie settingsAccessibility statement