Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Please help with API data formatting

Highlighted
8 - Asteroid

Hi Family,

I am facing a tricky issue with formatting the API Data

 

1. The data is not being correctly formatted. 

This is how I am getting the data now.

 

data_parameters_asset_iddata_parameters_asset_keydata_parameters_columns_0data_parameters_columns_1data_parameters_enddata_parameters_formatdata_parameters_intervaldata_parameters_orderdata_parameters_startdata_parameters_timestamp_formatdata_schema_descriptiondata_schema_first_availabledata_schema_last_availabledata_schema_metric_iddata_schema_minimum_intervaldata_schema_source_attribution_0_namedata_schema_source_attribution_0_urldata_schema_source_attribution_1_namedata_schema_source_attribution_1_urldata_schema_source_attribution_2_namedata_schema_source_attribution_2_urldata_schema_source_attribution_3_namedata_schema_source_attribution_3_urldata_schema_values_schema_circulating_marketcapdata_schema_values_schema_timestampstatus_elapsedstatus_timestampJSON_NameJSON_ValueString
51f8ea5e-f426-4f40-939a-db7e05495374usdttimestampcirculating_marketcap2020-05-01T00:00:00Zjson1dascending2019-01-01T00:00:00Zunix-millisecondsThe circulating marketcap is the price of the asset multiplied by the circulating supply. If no price is found for an asset because no trades occurred, the last price of the last trade is used. After 30 days with no trades, a marketcap of 0 is reported until trading resumes.2015-02-17T00:00:00Zmcap.circ1dMessarihttps://messari.ioKaikohttps://www.kaiko.com/Coinmetrics Community Datahttps://coinmetrics.io/community-network-data/Public BigQueryhttps://console.cloud.google.com/bigquery?p=bigquery-public-data&d=crypto_ethereum&page=datasetThe circulating marketcap in US dollars.Time in milliseconds since the epoch (1 January 1970 00:00:00 UTC)102020-05-28T01:07:04.084044342Z

 

I want the data to be:

 

status__elapsedstatus__timestampdata__parameters__asset_keydata__parameters__asset_iddata__parameters__startdata__parameters__enddata__parameters__intervaldata__parameters__orderdata__parameters__formatdata__parameters__timestamp_formatdata__parameters__columnsdata__schema__metric_iddata__schema__descriptiondata__schema__values_schema__timestampdata__schema__values_schema__circulating_marketcapdata__schema__minimum_intervaldata__schema__first_availabledata__schema__last_availabledata__schema__source_attribution__namedata__schema__source_attribution__urldata__values__001data__values__002
82020-05-27T23:34:52.018414694Zusdt51f8ea5e-f426-4f40-939a-db7e054953742019-01-01T00:00:00Z2020-05-01T00:00:00Z1dascendingjsonunix-millisecondstimestampmcap.circThe circulating marketcap is the price of the asset multiplied by the circulating supply. If no price is found for an asset because no trades occurred, the last price of the last trade is used. After 30 days with no trades, a marketcap of 0 is reported until trading resumes.Time in milliseconds since the epoch (1 January 1970 00:00:00 UTC)The circulating marketcap in US dollars.1d2015-02-17T00:00:00ZnullMessarihttps://messari.io1.5463E+122620842097
          circulating_marketcap     Kaikohttps://www.kaiko.com/1.54639E+122651080714
                  Coinmetrics Community Datahttps://coinmetrics.io/community-network-data/1.54647E+122651794623
                  Public BigQueryhttps://console.cloud.google.com/bigquery?p=bigquery-public-data&d=crypto_ethereum&page=dataset1.54656E+122656980637

 

How can I rearrange this?

2. If I have more than 1 linksto run into the API, I want them to be correctly identified e.g. This data is for USD or DAI:  "data__parameters__asset_key" column

How do I do it?

 

Thanks,

Harshad

Highlighted
15 - Aurora

The problem occurs in the Crosstab tool where the Name field is sorted alphabetically during the crosstab. To fix this, create a Record ID and add it as a prefix to the [Name] field, then remove it again afterwards.

 

Example attached.

 

DavidP_0-1590652834638.png

 

Highlighted
Alteryx
Alteryx

Hi,

 

Trying to wrap my head around your expected results and I'm guessing the URLs are the unique results that you have queried and data values are the values attributed to them?

Ultimately you will have to deal with them separately and piece them back at the end.

I created a quick example based on my assumption and here you go the workflow:

seinchyiwoo_0-1590653420406.png

 

Is this close to what you have in mind?

 

Cheers,

Seinchyi

Highlighted
8 - Asteroid

Thanks all,

You were close to what I was looking for however, it was not the complete result.

I have gone beyond what we were looking for hence, please excuse if the solution is an out-of-bounds one.

 

Thanks,

Harshad

Labels