I have a time stamping table which has data like No of Days ID 1 1D 2 2D
and so on till 30 days
Have another Dataframe with
start date and end date
I need to get the difference between these two days and get the ID from
Time Stamping table and do With Column .
The tedious solution is
val dfTimeStamping = df.withColumn("ID",when(Diff between Start date and
Enddate ,"1D").when(Diff between Start date and Enddate ,"2D")).. have to
do till 30 days .
How can I do it dynamically ?
Thanks,
Divya
