How to load this data?

ప్రతి వ్యక్తి పుట్టినప్పుడు సామాన్యంగానే పుడతారు. కాని ఎదిగేకొద్దీ.. ఎగిరేకొద్దీ.. పెరిగేకొద్దీ.. జీవితంలో ఒక్కో మలుపూ తిరిగే కొద్దీ.. జీవితంలో ఒక్కోఅడుగూ వేసే కొద్దీ.. అసామాన్యులుగా నిలబడాలి.

Task1:

How to load Product data starting with T and B. You should not load data starting with S and C.
That means load only these records by using filer/where condition.

T001
T002
T003
B001
B002
B003

Output:Capture.PNG

Download this file  >>> Data

Task2:

I only want to show users who have completed all 3 Test (status Complete).
In the example below only User A,D,E would be returned having completed all 3 test.

DATA:
load * inline [
User,Test Type,Status
User A,Test 1,Complete
User A,Test 2,Complete
User A,Test 3,Complete
User B,Test 2,Registered
User C,Test 1,In Progress
User C,Test 3,Complete
User D,Test 1,Complete
User D,Test 2,Complete
User D,Test 3,Complete
User E,Test 1,Complete
User E,Test 2,Complete
User E,Test 3,Complete
];

Output:

Capture.PNG

Task 3:

Data:
LOAD * INLINE [
OrderDate , Month ,Client , Sales
2018-03-16,3,Gopi,1000
2018-03-18,3,Ramesh,1500
2018-04-10,4,John Saida,2000
2018-05-13,5,Mocharla,3000
2018-06-11,3,Juneboyina,1500
2018-06-09,4,Shaik,2000
];

How to show Month on Month Growth rate? Like below?

MoM.PNG

 

Task4:

How to write set analysis to sum of Sales for 90 days.

Data:
LOAD * INLINE [
Name,Date,Sales
Gopi,2-Oct-2018,1
Ramesh,1-Oct-2018,2
John Saida,30-Sep-2018,3
Gopi,29-Sep-2018,1
Ramesh,28-Sep-2018,2
John Saida,27-Sep-2018,3
Gopi,26-Sep-2018,4
Ramesh,25-Sep-2018,5
John Saida,24-Sep-2018,1
Gopi,23-Sep-2018,2
Ramesh,22-Sep-2018,3
John Saida,21-Sep-2018,1
Gopi,20-Sep-2018,2
Ramesh,19-Sep-2018,3
John Saida,18-Sep-2018,4
Gopi,17-Sep-2018,5
Ramesh,16-Sep-2018,1
John Saida,15-Sep-2018,2
Gopi,14-Sep-2018,3
Ramesh,13-Sep-2018,1
John Saida,12-Sep-2018,2
Gopi,11-Sep-2018,3
Ramesh,10-Sep-2018,4
John Saida,9-Sep-2018,5
Gopi,8-Sep-2018,3
Ramesh,7-Sep-2018,3
John Saida,6-Sep-2018,3
Gopi,5-Sep-2018,3
Ramesh,4-Sep-2018,3
John Saida,3-Sep-2018,4
Gopi,2-Sep-2018,4
Ramesh,1-Sep-2018,4
John Saida,31-Aug-2018,4
Gopi,30-Aug-2018,4
Ramesh,29-Aug-2018,4
John Saida,28-Aug-2018,4
Gopi,27-Aug-2018,4
Ramesh,26-Aug-2018,4
John Saida,25-Aug-2018,4
Gopi,24-Aug-2018,4
Ramesh,23-Aug-2018,4
John Saida,22-Aug-2018,4
Gopi,21-Aug-2018,4
Ramesh,20-Aug-2018,4
John Saida,19-Aug-2018,4
Gopi,18-Aug-2018,4
Ramesh,17-Aug-2018,4
John Saida,16-Aug-2018,4
Gopi,15-Aug-2018,4
Ramesh,14-Aug-2018,5
John Saida,13-Aug-2018,5
Gopi,12-Aug-2018,5
Ramesh,11-Aug-2018,5
John Saida,10-Aug-2018,5
Gopi,9-Aug-2018,5
Ramesh,8-Aug-2018,5
John Saida,7-Aug-2018,5
Gopi,6-Aug-2018,5
Ramesh,5-Aug-2018,5
John Saida,4-Aug-2018,5
Gopi,3-Aug-2018,5
Ramesh,2-Aug-2018,5
John Saida,1-Aug-2018,5
Gopi,31-Jul-2018,5
Ramesh,30-Jul-2018,5
John Saida,29-Jul-2018,5
Gopi,28-Jul-2018,5
Ramesh,27-Jul-2018,5
John Saida,26-Jul-2018,5
Gopi,25-Jul-2018,6
Ramesh,24-Jul-2018,6
John Saida,23-Jul-2018,6
Gopi,22-Jul-2018,6
Ramesh,21-Jul-2018,6
John Saida,20-Jul-2018,6
Gopi,19-Jul-2018,6
Ramesh,18-Jul-2018,6
John Saida,17-Jul-2018,6
Gopi,16-Jul-2018,6
Ramesh,15-Jul-2018,6
John Saida,14-Jul-2018,6
Gopi,13-Jul-2018,6
Ramesh,12-Jul-2018,6
John Saida,11-Jul-2018,6
Gopi,10-Jul-2018,6
Ramesh,9-Jul-2018,6
John Saida,8-Jul-2018,6
Gopi,7-Jul-2018,6
Ramesh,6-Jul-2018,7
John Saida,5-Jul-2018,7
Gopi,4-Jul-2018,7
Ramesh,3-Jul-2018,7
John Saida,2-Jul-2018,7
Gopi,1-Jul-2018,7
Ramesh,30-Jun-2018,7
John Saida,29-Jun-2018,7
Gopi,28-Jun-2018,7
Ramesh,27-Jun-2018,7
John Saida,26-Jun-2018,7
Gopi,25-Jun-2018,7
Ramesh,24-Jun-2018,7
John Saida,23-Jun-2018,7
Gopi,22-Jun-2018,7
Ramesh,21-Jun-2018,7
John Saida,20-Jun-2018,7
Gopi,19-Jun-2018,7
Ramesh,18-Jun-2018,7
John Saida,17-Jun-2018,7
Gopi,16-Jun-2018,8
Ramesh,15-Jun-2018,8
John Saida,14-Jun-2018,8
Gopi,13-Jun-2018,8
Ramesh,12-Jun-2018,8
John Saida,11-Jun-2018,8
Gopi,10-Jun-2018,8
Ramesh,9-Jun-2018,8
John Saida,8-Jun-2018,8
Gopi,7-Jun-2018,8
Ramesh,6-Jun-2018,8
John Saida,5-Jun-2018,8
Gopi,4-Jun-2018,8
Ramesh,3-Jun-2018,8
John Saida,2-Jun-2018,8

];

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.