Forum Discussion
Hello @bojanvelevski,
Sometimes we may have to run the pipeline with old dates due to any issue in our server, network or third-party outages hence I need to pass a date like 2022-11-20, but generally it will be today’s date so I have to use the expression. We don’t care about timestamp only the date in format YYYY-MM-DD.
Also, please help me little more on what you explained in above reply. I am using it as below as of now -
When you need to run the pipeline with earlier dates, is it going to be a manual configuration and run?
You can simply configure the BatchParameterD1 like this:
_Effective_Date == "" ? Date.now().toLocaleDateString() : _Effective_Date
That way, if the parameter is not empty, it will be taken into consideration, if it is, than the current date will be generated.
- dipanjan_pan5 years agoNew Contributor
Thanks a lot @viktor_n …it works
Hi Dipanjan,
You can use the string method charCodeAt
e,g
($Column1.toLowerCase().charCodeAt(0) - 97) + 1
I’m not understanding your example. If Column 2 is supposed to be your rownum() value, why wouldn’t the values be 1, 2, 3, 4, 5 instead of 1, 1, 1, 2, 3?
- dipanjan_pan5 years agoNew Contributor
rownum based on some partition by column. In this case I want the output based on column 1. thats why it is 1,1,1,2,3
Related Content
- 3 years ago
- 8 years ago
- 2 years ago