Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have like
t1:
load
sales
amount
from sales.xlsx
now i am talikng resident for this
load
sales
'last_sales' as endsales
amount
resident t1;
here created a flag called 'endsales' i understood
my question what is the data in inside the field of 'endsales' i guess data would be 'last_sales'
if not pls correct me ?
if yes what is the use of this flag here?
Hi,
Here like this u vl get the data
Sales Endsales
100 last_sales
200 last_sales
130 last_sales
290 last_sales
300 last_sales
Hi,
Here like this u vl get the data
Sales Endsales
100 last_sales
200 last_sales
130 last_sales
290 last_sales
300 last_sales
Hi,
You get last_sales string in all rows in the t1 table
sales, endsales , amount
7841, last_sales, 45812
...
...
Regards
Anand
Your table will be loaded like this :
Sales Endsales Amount
100 last_sales 10
200 last_sales 50
130 last_sales 30
290 last_sales 10
300 last_sales 40
This flag is not useful until you are loading other tables as well like
If you load other table where you need to have flag 'Start_Sales' to identify the start sales amount.
Now in your expression you can use these flags to identify which amount belongs to END_SALES and which belongs to START_SALES .
Hope this help.