Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
See below image,
I have 1 execution date and OrderAge field...
when i am reload tomorrow i want add date and OrderAge
EX
Key CoverageStatus Execution_Date Order_Age
asd True 2/12/2014 1
pasd False 2/12/2014 6
when i am reload tomorrow i want add 2 columns and Order_Age Increasing with +1
like this
Key CoverageStatus Execution_Date Order_Age Execution_Date Order_Age
asd True 2/12/2014 1 2/13/2014 2
pasd False 2/12/2014 6 2/13/2014 7
Thanks in Advance......................
And the day after tomorrow? Do you then need 4 more columns compared to today?
Oh my,
that is indeed somewhat complicated:
- I'd do it in a LOOP (rather say, I'd try...)
- Count from day x (0,1,2,3 ...)
- Depending on that value, join fields with (reloaddate()-x)
- For the Order_Age, you have a starting_value and you just add your loop_value to it, that way it will increase by 1 every day.
HTH
Best regards,
DataNibbler
Hi Sunil
See the Attached.
Hi Gysbert,
Like this
When i am reload everyday i want to add 2 columns, like this
Key CoverageStatus Execution_Date Order_Age Execution_Date Order_Age Execution_Date OrdAge
asd True 2/12/2014 1 2/13/2014 2 2/14/2014 3
pasd False 2/12/2014 6 2/13/2014 7 2/14/2014 8
If you have to do this everyday than you can use Today() Date in Variable and in expression add +1 to both Date and Age.
Don't create extra columns, but load each days records in the same columns. Then use a pivot table to show the Execution_Date values horizontally instead of as a column. You can use an expression to show the Order_Age for the date value.
Hi, I am using pivot table but i am not getting properly.........
Hi ALL,
PFA,
How to write expression Here?
