2. For field First date and Last date there are some calculations.
First date - Display Bid value Day before Yesterday
Last date - Display Bid value Yesterday.
--- Can we know what kind of expression is used in calculating BidValue? Where is this BidValue coming from?
2. If i write a load query can i write where clause or filter column wise logic
Bid as First date where Date = Today()-2 ,
Bid as Last date where Date = Today()-1
From ABC table.
--- You cannot have Where statement inside LOAD so you can use an IF statement if you want. Like
LOAD ISIN, QuoteName,
IF([First date] = Today()-2, [First date]) AS BidFirstDate,
IF([Last date] = Today()-1, [Last date]) AS BidLastDate
Please share your sample data or qvw file to get more help.