Peek clarification

[Anonymous]

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,

[Chanty4u]

peek(Export_LastStatusChange_Date)

is your  New columnNme

[Chanty4u]

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;

[sunny_talwar]

Where are you seeing this?

Export_LastStatusChange

Do you may be mean Export_LastStatusChange_Date?

[Anonymous]

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

[sunny_talwar]

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