Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I could find that below logic is used in one dashboard script, but can not find 'Export_LastStatusChange', Could you please help me understand this logic?what it does?
if (Previous ([stat])=[Index du statut], Peek ('Export_LastStatusChange_Date'),Date(Period_Date))) AS Export_LastStatusChange_Date,
peek(Export_LastStatusChange_Date)
is your New columnNme
try with simple example
Data:
LOAD * INLINE [
ID, Value
1, 1
2, 2
3, 3
];
CONCATENATE (Data)
LOAD 4 as ID,
peek('Value') as Value
AUTOGENERATE 1
;
exit SCRIPT;
Where are you seeing this?
Export_LastStatusChange
Do you may be mean Export_LastStatusChange_Date?
its getting loaded in this script, but no peek table or column
LOAD *,
ApplyMap('NillInvoice',[ID de facture IP],null()) AS Nill,
AutoNumberHash256([ID de facture IP]) AS Facture_id,
text(if (Previous ([ID de facture IP])<>[ID de facture IP], [Index du statut],
if (Previous ([Index du statut])=[Index du statut], Peek ('Export_Histo_Status'),
Peek ('Export_Histo_Status') &'->'& [Index du statut]))) AS Export_Histo_Status,
if (Previous ([ID de facture IP])<>[ID de facture IP], Date(Period_Date),
if (Previous ([Index du statut])=[Index du statut], Peek ('Export_LastStatusChange_Date'),Date(Period_Date))) AS Export_LastStatusChange_Date,
if(Previous([ID de facture IP])<>[ID de facture IP],date(Max_Approval_Date),
if(isnull(Max_Approval_Date),Peek('Export_Max_Approval_Date'),date(Max_Approval_Date))) AS Export_Max_Approval_Date
Resident EXP_QUERY_QVD_ALL
its getting loaded in this script, but no peek table or column
What do you mean by this? no peek table or column? I don't think I understand