Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have used crosstable while loading data to qlikview.
Directory;
CrossTable
(Datecoded, Data)but the field " Datecoded "showing in number format. i just want it in MM-DD-YYYY format.
Normally i use date(Datecoded, 'MM-DD-YYYY') as Datecoded],
but i dont know to use the same when cross table is used.
Please guide me.
Lot of thanks in advance.
Hello,
I'm guessing but it may be
CROSSTABLE (Datecoded, Data) LOAD Date(Datecoded) AS Datecoded, Data FROM ...
Hope that helps
it doesnt work dude, 😞
You must evaluate your date:
Map_Extradata:
Directory;
CrossTable(YourDate, Data,3)
LOAD * FROM
[\\telesto\Base para QV\Balance & Cta. Resultados\Datos adicionales resultados.xlsx]
(ooxml, embedded labels, table is Plano);
LOAD
Fila,
Concepto,
Empresa,
Date(Num(Evaluate(YourDate) )) as "Posting Date",
Datos as Amount
Resident Map_Extrasata;
Drop Table Map_Extradata;