Question

Rows in Columns


Badge +5

As you can see, when I extract the data, it's showing me all "advrnum" with "td".Screenshot 2023-06-29 at 11.31.10 PM 

but when I merger them so I get only one recoder of Advr 8

 

I need all rows.

 

Screenshot 2023-06-29 at 11.33.29 PMScreenshot 2023-06-29 at 11.32.50 PM


16 replies

Userlevel 5
Badge +32

Hi @asadamjad​ , COuld you share your data?

Badge +5

https://www.nhc.noaa.gov/CurrentStorms.json

 

check mostLikelyTimeTSWindsGIS

O ad 1

Userlevel 5
Badge +32

Can you give us a bit more information about what you want to achieve here?

Badge +5

i dont wanna merge at the moment its merging popupinfo

Badge +5

anyone

Userlevel 5
Badge +40

So don't merge?

It is very hard to help you when you give such scant information. What are you trying to achieve here?

By the way, at this moment CurrentStorms.json does not contain any storms.

Badge +5

now you can try

Userlevel 5
Badge +40

Yes, there is one current storm mentioned now.

So what are you trying to accomplish, and what problems do you encounter?

image

Badge +5

Check mostLikelyTimeTSWindsGIS file

"https://www.nhc.noaa.gov/storm_graphics/api/EP032023_007adv_most_likely_toa_34.kmz"

Userlevel 5
Badge +40

Expose the attribute mostLikelyTimeTSWindsGIS.kmzFile in the JSONFragmenter, and use the attribute as the Dataset in a FeatureReader set to format Google KML.

image

Badge +5

where is the data? columns are empty

Badge +5

check the Workspace

 

 

Badge +5

Output should come like this

Userlevel 5
Badge +40

These attributes are part of the JSON file, they just need to be exposed in the JSONFragmenter, and renamed to the attribute names you give them.

Unfortunately I cannot open your workspace, as I use an older version of FME.

Badge +5

what version you have?

 

and you can open newer version to please help me out

Userlevel 5
Badge +40

All the information you need is present, and can be extracted using only a few transformers. I am doing my best to help you to get there. But I cannot solve it for you, I can only try to point you in the right direction.

 

As far as I can see, you rename attribute 'id' to 'stormid', and 'name' stays 'name'.

'advnum' is present in several attributes, it is not clear which one you are trying to use. What attributes you rename to 'popupinfo' and 'snippet' is unclear.

image 

P.S. I cannot install a new version, as I am on a computer of my employer.

Reply