Qlik to Snowflake logic

[Bharathi09]

Hi All,

I am working on replicating qlik logic in snowflake, need help on below code WHERE Condition

Parts:
LOAD Distinct
[IDate],
cntnr,
orgn

FROM
[$(vQVDPath)Parts_Transformed.qvd]
(qvd)
where Match(orgn,'US','CA','MX');
store Parts into $(vQVDPath)Part.qvd;

NoConcatenate
Parts_MaxDate:
LOAD Distinct
[Date],
cntnr,
orgn

Resident Parts
where cntnr <> Previous(cntnr)
Order by cntnr, [Date] desc;

drop Table Parts;
store Parts_MaxDate into $(vQVDPath)Parts_MaxDate.qvd;

Please help
Thanks

[sbaro_bd]

Hi @Bharathi09,

Explore the SQL WITH statement. Let us know if it is helpful.

Regards.

[MarcoWedel]

which one, there are two? what is the issue?

[Bharathi09]

@MarcoWedel Hi, Thanks for replying 

Parts_maxdate table. Mainly I am looking for where condition 

[Bharathi09]

Hi , 
Can you please help me on where condtion below , how to write it in SnowFlake

where cntnr <> Previous(cntnr)
Order by cntnr, [Date] desc;

Thanks

[MarcoWedel]

I think the Previous()-function would translate into LAG() OVER ... in Snowflake SQL