Extracting/appending Columns

[Anonymous]

Hello, 

Currently I am trying to display weather data alongside reference time in a data set. However, they are both stored in lists, and whenever I try to extract/expand to rows or consolodate my data im not able to represent it correctly. Right now, my table has airport IATA codes, cloud cover, and UTC times in Unix. each list is 72 data points for the 72 hour forecast (im trying to line them up).  the table I am trying to achiveve would be:

[IATA]   [CLOUD COVER]    [UTC TIME]   

LSG                 15                         1234

LSG                 45                           1235

LSG                  34                        1236

etc....

Can I epxand multple columns at once?

table right now.

My plan is to make a composite key for the table and link it to a flight data set for departures. 

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please download the demo from the attachment. All the step are done in the Query Editor. 

Best Regards,
Dale

[Anonymous]

@v-jiascu-msft Hey Dale, 

I followed your steps to the letter. I really think it'll work, but i'm being stonewalled by what i think is either the API source or pivot function. Whenever I move to pivot the attribute column along values, the process freezes up. i've tried limiting my data (10-12 hours) but still hit the same issue. frozen after pivot step

Is there a way to just freeze my data and worry about updating after i format the table? because it keeps trying to validate from the source during the Pivot. 

[v-jiascu-msft]

Hi @Anonymous,

What we can see in the Query Editor is a preview. It should validate the data for every step. I would suggest you filter rows by "Keep top rows" after the step "Removed other columns1". You can keep only 5 rows. Then delete this step after everything is done. Finally, there is only one long run.

Best Regards,
Dale