Load editor and variable number of column + REST connector

[alexandernatale]

Number of column variable in load editor Hi everyone, I have a problem with a data table with such a structure

| Area | Location | Day1 | Day2 | .. | Day n |

when writing loader I would like to transform this structure into a more usable form.

I have seen the crosstable function and it works but only if the structure is "static". In my case, however, a column is added every day ... how can I solve?

I try this:

RestConnectorMasterTable:

SQL SELECT "Area", "Location", "Day1", "Day2", ... "DayN",

FROM CSV (header on, delimiter ",", quote """") "CSV_source";

[Temp]: CrossTable (Datatemp, Totalcasestemp, 2)

LOAD * RESIDENT

RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

[Totalcases]:

Load "Area", "Location", Date (date#(Datatemp, 'M/DD/YY'), 'DD/MM/YY') as Data,

Totalcasestemp as Totalcases RESIDENT [Temp];

Drop Table [Temp];

But in this case the SQL String don't accept " * " to select all columns... Any suggestions????

[marcus_sommer]

I think this will be helpful in regard why you couldn't apply a wildcard-load:

REST-API-data-Select-All-Fields 

- Marcus

[alexandernatale]

@marcus_sommer

thanks for your reply.

I use a REST connector but can I change this connector. The page that i use to connect the data is the follow:

https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/...

i use this page: https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_ti...

to connect my script loader with REST connector. I use another connector to have same result?

thank you so much

[marcus_sommer]

You may try to load this csv as flat-file.

- Marcus

[alexandernatale]

thanks @marcus_sommer  for reply.

Can you help me to find flat connector?
I use Qliksense business (SaaS) (ex cloud) and I have this connector

 

[marcus_sommer]

I never used Qliksense business (SaaS) - is there no file-wizard available?

- Marcus